SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Administration, System Tables Rss

   Items 1 to 2 of 2   

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,344 reads

What is sysprocesses and what can it do for you?

This article presents a description of sysprocesses aimed at the newer DBAs. From new author Edward Elliot, he dives into what you can learn from this system view.  Read more...
By Edward Elliott 2009/05/01 | Source: SQLServerCentral.com | Category: system tables
Rating: |  Discuss |   Briefcase | 14,207 reads
   Items 1 to 2 of 2   
best practices (1)    
dba (1)    
nightly jobs (1)    
sql server agent (1)