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

Guest Columnist: Alok Dwivedi

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

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,718 reads

Changing Table Schema – what goes behind the scenes – Part II

Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.  Read more...
By Alok Dwivedi 2009/08/05 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 4,630 reads

Changing Table Schema – what goes behind the scenes – Part I

What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.  Read more...
By Alok Dwivedi 2009/08/03 | Source: SQLServerCentral.com | Category: design and theory
Rating: |  Discuss |   Briefcase | 7,555 reads
   Items 1 to 3 of 3