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

Articles with tag Foreign Keys (FK) Rss

Search for any content tagged foreign keys (fk)

   Items 1 to 20 of 22    Older >>
 

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 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 11,919 reads

Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

Denzil Ribeiro looks at the validation phase of transaction lifetime.  Read more...
By Additional Articles 2016/05/20 | Source: Microsoft MSDN | Category: memory optimized tables
Rating: (not yet rated)  Rate this |   Briefcase | 2,123 reads

Trust, or Verify – How FKs Can (or Cannot) Help Performance

Learn how trusted foreign keys (FK) can help or hurt performance.  Read more...
By Hugo Kornelis 2016/03/08 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,210 reads

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: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,251 reads

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 keys (fk)
Rating: |  Discuss |   Briefcase | 2,780 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 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 11,919 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: SQLServerCentral.com | 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: MSSQLTips.com | Category: foreign keys (fk)
Rating:  Rate this |   Briefcase | 8,196 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 key (pk)
Rating: (not yet rated)  Rate this |   Briefcase | 9,533 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,371 reads

Ordered Loading of Databases Tables Using SSIS

Finding the load order for inserting data into a that respects referential integrity is sometimes difficult. If you are using SSIS, the task is made easier.  Read more...
Rating: |  Discuss |   Briefcase | 4,615 reads

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,634 reads

An Introduction to Database Design

An introduction to database design for those people that might not understand what is involved.  Read more...
By Paul White 2013/01/11 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 25,313 reads

Using DELETE CASCADE Option for Foreign Keys

Referential integrity is a very important thing to consider when designing a database. In my years as a DBA I've seen database designs that sit on both ends of the spectrum, none at all and cases where every table is linked to multiple tables. While the later certainly can be a little more difficult to work with it ensures the integrity of your data stays intact. The other end provides much more flexibility when it comes to updating and deleting data from your database, whether it's being done through the application or directly on the backend, but has the issue of possible orphan records if things are not done properly. This tip will look at the DELETE CASCADE option when creating foreign key constraints and how it helps keep the referential integrity of your database intact.  Read more...
By Additional Articles 2012/08/13 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 3,624 reads

Holy Foreign Keys and Indexes

This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.  Read more...
By James DiMauro 2011/10/10 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 5,378 reads

SQL Server Foreign Key Update and Delete Rules

Foreign key constraints are an integral part of SQL Server database design. These are used to maintain integrity among related data in different tables. While implementing update and delete operations on values in the parent table (referenced table with primary key) we have to consider the impact on related values in the child table. SQL Server provides different rules for managing the effect of updates and deletes on child table values. How can these rules be used effectively without threatening the relational integrity?  Read more...
By Additional Articles 2011/05/03 | Source: MSSQLTips.com | Category: foreign keys (fk)
Rating:  Rate this |   Briefcase | 4,534 reads

An Introduction to Database Design

An introduction to database design for those people that might not understand what is involved.  Read more...
By Paul White 2013/01/11 (first published: 2011/01/18) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 25,313 reads

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,634 reads

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...
By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,759 reads

Foreign Key Constraints Revisited

Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.  Read more...
By Additional Articles 2009/08/05 | Source: Database Journal | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 2,792 reads
   Items 1 to 20 of 22    Older >>