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,417 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
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,429 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,316 reads
Blogs
Reviewing 2019 Career Goals
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Forums
Automatic Redaction of PII
Comments posted to this topic are about the item Automatic Redaction of PII
Find Strings Containing Hex Range
I have a table with a varchar field. It contains a number of characters...
How to implement row last access date column
I'm creating a table to store serialized shopping cart data associated with a user...
Ask SSC