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

Content with tags Indexing, deadlocks Rss

   Items 1 to 2 of 2   

Using a Clustered Index to Solve a SQL Server Deadlock Issue

At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error  Read more...
By Steve Jones 2011/11/01 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 4,684 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,767 reads
   Items 1 to 2 of 2   
foreign keys (fk) (1)    
performance tuning (1)    
t-sql (1)