Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

   Items 1 to 6 of 6   

Alert! Alert! Backup and Restore Baby!

Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading.   Read more...
By Jeremy Kadlec 2004/01/08 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 11,034 reads

Create Maintenance Job with a Click without using a Wizard

Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.   Read more...
By Robin Back 2003/08/20 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 9,638 reads

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: | Category: administration
Rating: |  Discuss |   Briefcase | 19,981 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: | Category: installation
Rating: |  Discuss |   Briefcase | 18,207 reads

Managing Jobs Using TSQL

We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.   Read more...
By Randy Dyess 2003/04/02 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 23,755 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: | Category: administration
Rating: |  Discuss |   Briefcase | 10,450 reads
   Items 1 to 6 of 6   
administration (6)    
configuring (3)    
performance tuning (2)    
backup and restore (1)    
database design (1)    
distributed queries (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
naming standards (1)    
openxml (1)    
programming (1)    
replication (1)    
security (1)    
sql-dmo (1)    
stored procedures (1)    
strategies (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)