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,510 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,449 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,459 reads
Blogs
Daily Coping 18 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure Cosmos DB – HTAP using Azure Synapse Link
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Azure Cosmos DB – HTAP using Synapse Analytics
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Forums
Event log filling up with Sql error
Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...
How to do Join
Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...
Connect to PostgreSQL as an External Data Source using PolyBase
Comments posted to this topic are about the item Connect to PostgreSQL as an...
Ask SSC