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,495 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
494 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,448 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,433 reads
Blogs
The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It
By todd-32417
Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!
The Post Pandemic Office Experience
By Steve Jones
I traveled to Pasadena, CA this week to work with a few other Redgaters...
Connecting to Azure Blobs in Power BI
By DataOnWheels
The step-by-step process below walks through connecting to data housed in Azure Blob Storage...
Forums
Get the last day of the year based on a date range
I am trying to get the last day of the year from a date...
Put two queries together
Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...
Excel Formula to create SQL Script for a Values Table
Comments posted to this topic are about the item Excel Formula to create SQL...
Ask SSC