Anil Singh | Code-sample.com

What is Nonclustered Index? Non-Clustered Index, 1.       Non-clustered indexes  can be used more than one time per table. 2.       Non-clustered indexes store logical structure but clustered indexes store in physical order. 3.       Faster for insert and update operations than a clustered index. 4.       Improve the performance when select data with index fields. 5.       Non-clustered indexes are stored separately. 6.       We can add only 249 non-clustered indexes for a table. 7.       Non-clustered indexes made on the any key but clustered indexes only on primary keys. How to create Nonclustered Index? -- CREATE NONCLUSTERED INDEX CREATE NONCLUSTERED INDEX Indexname_Employee ON Employee (     [EmpName] ASC --OR DESC,     [EmpDepartment] ...

ALTER PROCEDURE [dbo] . [sp_GetCustomer] --'343'             -- Add the parameters for the stored procedure here     @CustomerID NVARCHAR ( 50 ) AS BEGIN             -- SET NOCOUNT ON added to prevent extra result sets from             -- interfering with SELECT statements.             SET NOCOUNT ON ;     -- Insert statements for procedure here             SELECT   CUST . CustomerID ,                                     CUST . CustomerName       ...