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

Content with tags Strategies, T-SQL, Miscellaneous, 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,052 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,188 reads
   Items 1 to 2 of 2   
 
Tags
sql server 7 (2)    
administration (1)    
backup / restore (1)    
configuring (1)    
performance tuning (1)