CheckDB Error Msg 824 level 24
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for… Read More »CheckDB Error Msg 824 level 24
Running DBCC CheckDB for all of your databases – quick script
Running DBCC CHECKDB DBCC CHECKDB is one of the most essential tools in the SQL Server arsenal, providing a detailed examination of your database’s structural… Read More »Running DBCC CheckDB for all of your databases – quick script
Another Successful Corruption Repair
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were… Read More »Another Successful Corruption Repair
PASS Summit 2018 – Hope to see you there
My presentation is on the Exploring SQL Server Join Types – INNER, OUTER, and Much More More details…
Prevent Server Manager From Loading
If you frequently connect to many different SQL Server as I do, you are probably used to the Server Manager loading slowly when you log… Read More »Prevent Server Manager From Loading
2018 PASS Summit Community Speakers Announced
Today was the announcement of the 2018 PASS Summit Community Speakers, and I am fortunate enough to have been included on that list for the… Read More »2018 PASS Summit Community Speakers Announced
DBCC CheckDB or CheckTable – Find percent complete
You have a DBCC CHECKDB script running, something like the following, and it may take several hours to run to confirm if there is any… Read More »DBCC CheckDB or CheckTable – Find percent complete
Corruption Repair Complete
This weekend the Stedman Solutions team had the opportunity to help a new client repair their corrupt database. By Sunday evening we had their database… Read More »Corruption Repair Complete
Combining many SQL files into one
I come across the need occasionally to deploy a set of sql files that are all checked into source control in different files with a… Read More »Combining many SQL files into one
Weird Join Delete
This confused me for a few minutes today and I wanted to share to help avoid further confusion.
The specific code was this:
DELETE t2 FROM [dbo].[Table1] t1 INNER JOIN [dbo].[Table2] t2 on t1.favColor = t2.id;
Names have been changed to protect the innocent.
In the above delete statement which table will have rows deleted from it?
A: Table1
B: Table2
C: Both Table1 and Table2
D: Neither Table1 and Table2