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,480 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,444 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,413 reads
Blogs
T-SQL Tuesday Retrospective #015: Automation
In February 2011, Pat Wright invited us to talk about Automation: So the topic...
Daily Coping 12 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Updated Pluralsight Course – Managing the Kubernetes API Server and Pods
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Forums
SQL 2012 Standard - Index highly fragmented
Hi there, Complete newb. Need some guidance. Running SQL 2012, running INFOR ERP. Indexes...
Manual tasks in SSIS design
Hi, I am getting CSV files with hundreds of columns many of which have...
Loading a csv file into sql server table
Hi, I've created a simple dataflow with flat file source and sql server destination....
Ask SSC