Non Clustered Index in SQL Server

In my previous article on "Clustered Index in SQL Server" we talked about creating a Clustered Index. In this article we will talk about creating a Non-Clustered Index. Non Clustered Index: Non Clustered index is a separate object. This doesn’t depend on how the data is stored in the table. So you can have more the one index on a table. When you create a primary key on any table by default SQL Server creates the clustered index. To avoid this you need to use NONCLUSTERED keyword in the primary key creation script.