Holy Foreign Keys and Indexes
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
2011-10-10
5,453 reads
This article shows an interesting issue with foreign keys and how they are aligned with the base tables in SQL 2005 SP 4.
2011-10-10
5,453 reads
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
2011-08-17
493 reads
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
2009-08-26
8,438 reads
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
2009-08-07 (first published: 2008-07-14)
20,378 reads
When you don't have statistics, what does SQL use to calculate the estimated number...
By Ed Elliott
This is a bit of a longer one, a look at how to do...
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
I have a requirement whereby testers on ServerA need a copy of the production...
I need to get value portion key to every 3 row on one row...
We have sharepoint as the data source and we have 2 dates created...