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

Articles with tag System Tables Rss

Search for any content tagged system tables

   Items 1 to 3 of 3   

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: | Category: foreign key
Rating: |  Discuss |   Briefcase | 2,740 reads

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: | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,312 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: | Category: system tables
Rating: |  Discuss |   Briefcase | 14,000 reads
   Items 1 to 3 of 3