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,436 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,351 reads
Blogs
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....
Forums
How to know which index is invalid index on a table?
There are about thirty fields in a table SaleOrderLines, I created some indexes ,...
Thanksgiving 2020
Comments posted to this topic are about the item Thanksgiving 2020
Thanksgiving Visualizations
Comments posted to this topic are about the item Thanksgiving Visualizations
Ask SSC