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

Content with tags T-SQL, Miscellaneous, SQL Server 7, 2000, Monitoring, Performance Tuning and Scaling, Administering Rss

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

Configuring (2)     English Query (1)     Replication (1)     UpdateGrams (1)    
Backup and Recovery (1)     Indexing (1)     Security (1)     User-Defined functions (1)    
Basic Querying (1)     Installation (1)     Stored Procedures (1)     XML (1)    
Distributed Queries (1)     OpenXML (1)     Triggers (1)     XSL (1)    
DTS (1)     Performance Tuning (1)    
   Items 1 to 2 of 2   
 

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 14,813 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: Installation
Rating: |  Discuss |  Briefcase | 17,520 reads
   Items 1 to 2 of 2