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,404 reads
James DiMauro
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
492 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,425 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,300 reads
Blogs
Why oh Why? Effects of Antivirus on a DB Server
At best these phantom backups cause undue headache in troubleshooting. At worst, they make...
Your First Jupyter Notebook
In April, I said I was going to start learning Jupyter Notebooks. It’s November....
Using Visual Studio Code
I’m a creature of habit. I have my routine when I get to my...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Turn If statement into Case
How can I convert this into a Case statement so that the query is...
The Conference Springboard
Comments posted to this topic are about the item The Conference Springboard
Ask SSC