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,400 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,291 reads
Blogs
Power BI Monthly Digest – October 2019
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
Database Fundamentals #24: Filtering Data
If you’ve been reading these Database Fundamentals posts, you’ve already seen the WHERE clause...
#PowershellBasics: The Windows Powershell icon in the task bar also lets you run Powershell ISE.
I don’t know about you, but I like having the tools that I’m likely...
Forums
More Network Restrictions
Comments posted to this topic are about the item More Network Restrictions, which is...
Performance Tuning Question?
What are best steps to take to performance tune sql server?
Execution Plan vs Statistics I/0?
Whats difference between using execution plans vs statistics i/o to analyze and troubleshoot in...
Ask SSC