--CREATE TABLE Employees (

-- Id INT PRIMARY KEY IDENTITY,

-- [Name] NVARCHAR(50),

-- Email NVARCHAR(50),

-- Department NVARCHAR(50)

-- )

-- Create the Employees table if it doesn't exist

IF OBJECT_ID('Employees', 'U') IS NULL

CREATE TABLE Employees (

Id INT PRIMARY KEY IDENTITY,

[Name] NVARCHAR(50),

Email NVARCHAR(50),

Department NVARCHAR(50)

)

DECLARE @Counter INT = 1

DECLARE @MaxRecords INT = 10000

WHILE @Counter <= @MaxRecords

DECLARE @Name NVARCHAR(50)

DECLARE @Email NVARCHAR(50)

DECLARE @Department NVARCHAR(50)

-- Generate random values for Name, Email, and Department (you can replace this with your own logic)

SET @Name = 'Employee' + CAST(@Counter AS NVARCHAR(10))

SET @Email = 'email' + CAST(@Counter AS NVARCHAR(10)) + '@company.com'

SET @Department = 'Department' + CAST((@Counter % 10) + 1 AS NVARCHAR(10))

-- Insert the record

INSERT INTO Employees ([Name], Email, Department)

VALUES (@Name, @Email, @Department)

SET @Counter = @Counter + 1

Select * from Employees where Id=999

Select * from Employees where Name='Employee999'

CREATE NONCLUSTERED INDEX IX_Employees_Name

ON [dbo].[Employees]([Name])

Select Name from Employees Where id= 536

Select Name, Email from Employees Where Name='Employee536'

Create Index IX_Employees_Name ON Employees (Name ASC)

Execute sp_helpindex Employees

create Clustered Index IX_Employees_Department_Email

ON Employees(Department DESC, Email Asc)

ALTER TABLE Employees

ADD CONSTRAINT UQ_Employees_Name

UNIQUE (Name)