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

Content with tag System Tables Rss

   Items 1 to 4 of 4   
 

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: SQLServerCentral.com | Category: foreign key
Rating: |  Discuss |   Briefcase | 2,519 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: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,307 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 | 13,985 reads

Find a Table's Metadata

Stored Procedure that returns table information  Read more...
By Crosbie Christopher 2008/10/23 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,352 reads
   Items 1 to 4 of 4   
 
Tags
administration (2)    
::fn_listextendedproperty (1)    
best practices (1)    
columns (1)    
dba (1)    
find foreign key using sql (1)    
foreign key (1)    
nightly jobs (1)    
primary key (1)    
sql server agent (1)    
stored procedures (1)    
table field information (1)    
table metadata (1)    
t-sql (1)