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

Content with tags Indexing, Editorial Rss

   Items 1 to 4 of 4   
 

Review Your Indexing

Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.  Read more...
By Steve Jones 2012/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 267 reads

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 | 286 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 | 403 reads

Keep It Simple

As we build more sophisticated maintenance procedures, we increase the complexity of our systems. Is that a good thing? Steve Jones has a few comments on what this means for DBAs.  Read more...
By Steve Jones 2009/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 185 reads
   Items 1 to 4 of 4   
 
Tags
database weekly (2)