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

Content with tag foreign keys Rss

   Items 1 to 9 of 9   

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 3,159 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2015/06/29 | Source: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 9,762 reads

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 | 290 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 | 8,125 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,452 reads

Running Out Of Foreign Keys

By Andy Warren 2014/05/20 | Category: foreign keys
Rating: (not yet rated) |  Discuss |   Briefcase | 1,754 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,380 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: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,327 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 | 847 reads
   Items 1 to 9 of 9   
indexing (2)    
binding (1)    
check constraints (1)    
custom metrics (1)    
editorial (1)    
mongodb (1)    
nosql (1)    
performance (1)    
primary keys (1)    
referential integrity (1)    
schemas (1)    
sql monitor (1)    
transactions (1)