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

Content with tags SQL Server 7, Strategies, Naming Standards Rss

   Items 1 to 5 of 5   

Standards Are a Good Thing

This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent.   Read more...
By Andy Warren 2003/04/09 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 6,154 reads

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 8,347 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

Worst Practice - Bad Comments

This one is pretty interesting, Andy discusses a few things he sees in comments that not only fail to add value, they end up costing extra time. There's room for discussion here, but definitely a discussion worth having - comments can make you or break you, here's a chance to think about what you think is important in commenting and pass that on to your development team.   Read more...
By Andy Warren 2003/01/23 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,423 reads

Interact with SQL Server's Data and Procedure Cache

This article briefly discusses SQL Server's data and procedure cache and shows you the common Transact-SQL statements/command and system tables that you can use to interact with the cache through Transact-SQL.   Read more...
By Randy Dyess 2002/08/15 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 13,814 reads
   Items 1 to 5 of 5   
administration (4)    
configuring (3)    
database design (3)    
miscellaneous (3)    
programming (3)    
t-sql (3)    
monitoring (2)    
best and worst practices (1)    
performance tuning (1)    
sql-dmo (1)    
stored procedures (1)    
worst practices (1)