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
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
My presentation is on the Exploring SQL Server Join Types – INNER, OUTER, and Much More More details…
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
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
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
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
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
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
The question came up as a blog comment of “To delete 100,000 row chunks from a 9,542,067 row table, how about” Thats a great question.… Read More »Q & A – Deleting lots of rows from a huge table.