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

Content with tags Administration, Foreign Keys (FK) Rss

   Items 1 to 3 of 3   
 

Foreign key

By Igor Micev 2012/04/06 | Category: database design
Rating: (not yet rated) |  Discuss |   Briefcase | 2,588 reads

Rename foreign key constraints (SQL Server 2005 & 2008)

Rename all FK constraint names in your database with the format ChildTableName_ParentTableName_ObjId_FK.  Read more...
By MadDan 2010/01/26 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 894 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,304 reads
   Items 1 to 3 of 3   
 
Tags
database design (1)    
indexing (1)    
maintenance and management (1)    
performance tuning (1)    
search (1)    
sql server 2005 (1)    
tables (1)    
t-sql (1)    
utility (1)