SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tags T-SQL, Strategies, Indexing, SQL Server 7, 2000 Rss

Refine your search with one of the following additional tags (with number of items):

Miscellaneous (2)     Configuring (1)    
Administering (1)     Performance Tuning (1)    
Backup and Recovery (1)    

Search for any content tagged T-SQL & Strategies & Indexing & SQL Server 7, 2000

   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 | 14,684 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: Administering
Rating: |  Discuss |  Briefcase | 7,980 reads
   Items 1 to 2 of 2