SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Strategies, Indexing Rss

   Items 1 to 2 of 2   

Cluster That Index!

Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.   Read more...
By Christoffer Hedgate 2003/03/30 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,119 reads

SQL Maintenance Plans - Under the Covers!

In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!   Read more...
By Andy Warren 2002/05/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,208 reads
   Items 1 to 2 of 2   
miscellaneous (2)    
sql server 7 (2)    
t-sql (2)    
administration (1)    
backup and restore (1)    
configuring (1)    
performance tuning (1)