Do Foreign Key Constraints Help Performance?
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,673 reads
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,673 reads
Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...
2010-11-19
659 reads
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,000 reads
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,153 reads
After all the conversations at FreeCon last week (more on that later, when I’ve assimilated it better), I finally decided...
2010-11-15
519 reads
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,883 reads
Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM...
2010-11-12
1,319 reads
Today is Dr. Dewitt.
The ballroom, where the keynotes are held, is filled with extra chairs. The Summit organizers expect extra...
2010-11-11
785 reads
Today is Kilt Day at the PASS Summit. We’re going to try to arrange a group photo at lunch time.
The...
2010-11-10
771 reads
Sitting at the big kids table at the PASS Summit, ready to rock and roll. The Summit has not officially...
2010-11-09
659 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Hello folks, I would be very grateful if someone could assist me with this...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers