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

Content with tags T-SQL, SQL Server 7, 2000, Miscellaneous, Configuring, Monitoring Rss

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

Administering (3)     DTS (1)     Performance Tuning (1)     Strategies (1)    
Performance Tuning and Scaling (2)     English Query (1)     Programming (1)     Triggers (1)    
Backup and Recovery (1)     Indexing (1)     Replication (1)     UpdateGrams (1)    
Basic Querying (1)     Installation (1)     Security (1)     User-Defined functions (1)    
Database Design (1)     Naming Standards (1)     SQL-DMO (1)     XML (1)    
Distributed Queries (1)     OpenXML (1)     Stored Procedures (1)     XSL (1)    
   Items 1 to 3 of 3   
 

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,439 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,395 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: Administering
Rating: |  Discuss |  Briefcase | 9,791 reads
   Items 1 to 3 of 3