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

Content with tags T-SQL, Foreign Keys (FK) Rss

   Items 1 to 14 of 14   

Temp Table Foreign Keys

By David Fundakowski 2016/08/02 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,170 reads


By Igor Micev 2015/03/24 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,149 reads

Foreign Key Fun

By Tom Thomson 2015/03/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,137 reads

Create Table

By Kapil Singh 2013/04/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,231 reads


By Nenad Zivkovic 2013/04/24 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,029 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: | Category: t-sql
Rating:  Rate this |   Briefcase | 3,605 reads

Foreign key

By Igor Micev 2012/05/18 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,969 reads

Violating Foreign Keys

By Chris Fradenburg 2011/10/25 | Category: foreign keys (fk)
Rating: (not yet rated) |  Discuss |   Briefcase | 2,440 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: | Category: foreign keys (fk)
Rating:  Rate this |   Briefcase | 4,526 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,284 reads

Implementing Most Recently Used Lookups

This script will adapt ordering of look-up lists by foreign key usage.  Read more...
By William Talada 2010/01/18 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 826 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,759 reads

The Ultimate Index-Less Foreign-Key Finder

Searches for foreign key constraints that don't have fully matching indexes. The best partial matching indexes are outputted with MatchCounts and column comparisons.  Read more...
By Jesse Roberge 2009/10/15 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,343 reads
   Items 1 to 14 of 14   
indexing (3)    
cascade deletes (2)    
performance tuning (2)    
administration (1)    
check constraints (1)    
constraints (1)    
create (1)    
deadlocks (1)    
execute (1)    
identity property (1)    
lookups (1)    
maintenance and management (1)    
primary key (pk) (1)    
search (1)    
sql server 2005 (1)    
table (1)    
tables (1)    
unique (1)    
utility (1)    
xml (1)