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
James DiMauro
- Interests: My kids and family.
My Experiences at SQL Saturday 64
A commentary of the experiences of James Dimauro at SQL Saturday #64 in Baton Rouge, LA in August 2011.
2011-08-17
493 reads
Moving Databases with the ALTER Command
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
A Story of the Deleted Transaction Log
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
Blogs
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Synapse Analytics and .NET for Apache Spark Example 4 - JOINS
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Recovering Data from a Backup with SQL Data Compare
By Steve Jones
I had a customer recently ask about how to recover data from a backup...
Forums
Accessing a RESTORING database for test refresh
I have a requirement whereby testers on ServerA need a copy of the production...
How to get value portion key to every rn from 1 to 3 row on one row?
I need to get value portion key to every 3 row on one row...
Median Processing time, Average Procesisng time for created/closed date
We have sharepoint as the data source and we have 2 dates created...
Ask SSC