Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag clustered indexes Rss

   Items 1 to 2 of 2   

When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more.  Read more...
By Additional Articles 2013/10/10 | Source: | Category: clustered indexes
Rating:  Rate this |   Briefcase | 5,591 reads

Primary Keys which are not Clustered Indexes in a database

Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.  Read more...
By Bodhisatya Mookherjee 2013/09/18 | Source: | Category: primary keys
Rating: |  Discuss |   Briefcase | 1,792 reads
   Items 1 to 2 of 2   
non-clustered index (1)    
primary keys (1)