Pages

Monday, August 19, 2013

SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key | Journey to SQL Authority with Pinal Dave

One of the basic Database Rule I have is that all the table must Clustered Index. Clustered Index speeds up performance of the query ran on that table. Clustered Index are usually Primary Key but not necessarily. I frequently run following query to verify that all the Jr. DBAs are creating all the tables with… Continue Reading...

Source: SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key | Journey to SQL Authority with Pinal Dave

No comments:

Post a Comment