Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag foreign keys Rss

   Items 1 to 7 of 7   

Limitations of MongoDb

This article looks at two critical limitations suffered by MongoDb compared with SQL Server.  Read more...
By Eric Notheisen 2015/03/10 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 203 reads

Drop and Re-Create All Foreign Key Constraints in SQL Server

Aaron Bertrand supplies a script which generates two separate sets of commands: one to drop all foreign key constraints, and one to create them again. These scripts are stored in a table so that, if you drop the constraints and then disaster of some kind strikes during the create, you still have everything handy and can troubleshoot if needed.  Read more...
By Additional Articles 2014/10/17 | Source: | Category: foreign keys
Rating:  Rate this |   Briefcase | 7,780 reads

Questions about Primary and Foreign Keys You Were Too Shy to Ask

It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.  Read more...
By Additional Articles 2014/10/14 | Source: SimpleTalk | Category: primary keys
Rating: (not yet rated)  Rate this |   Briefcase | 9,085 reads

Running Out Of Foreign Keys

By Andy Warren 2014/05/20 | Category: foreign keys
Rating: (not yet rated) |  Discuss |   Briefcase | 1,719 reads

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database  Read more...
By Bodhisatya Mookherjee 2013/09/11 | Source: | Category: schemas
Rating: |  Discuss |   Briefcase | 1,362 reads

New SQL Monitor Custom Metric: Untrusted Foreign Keys

A foreign key points to a primary key that must exist in another table, for example, column X in Table 1 must also be present in Table 2. The key protects this link, and only valid data can be inserted in the foreign key column. An untrusted foreign key may threaten a database‚Äôs referential and data integrity.  Read more...
By Press Release 2013/08/20 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,201 reads

Re-Trust Untrusted Foreign Keys and Constraints

This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.  Read more...
By Shaun J. Stuart 2013/06/17 | Source: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 640 reads
   Items 1 to 7 of 7   
check constraints (1)    
custom metrics (1)    
editorial (1)    
mongodb (1)    
nosql (1)    
primary keys (1)    
schemas (1)    
sql monitor (1)    
transactions (1)