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

Content with tags Indexing, Database Weekly Rss

   Items 1 to 2 of 2   
 

Fragmentation Fear

Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?  Read more...
By Tony Davis 2012/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 290 reads

Clustered Indexes? Sedimentary, my dear Watson

There is much sound advice suggesting that every table should have a clustered index, and that narrow, integer, ever-increasing columns, such as afforded by an IDENTITY column are the best choice. But is the sedimentary approach really the natural order of the day?  Read more...
By Tony Davis 2010/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 404 reads
   Items 1 to 2 of 2   
 
Tags
editorial (2)