SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

   Items 1 to 2 of 2   

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,768 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,356 reads
   Items 1 to 2 of 2   
administration (1)    
deadlocks (1)    
maintenance and management (1)    
search (1)    
sql server 2005 (1)    
tables (1)    
utility (1)