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 customers with great success. DBCC results for ‘YourDatabaseName’. CHECKDB found 0 allocation errors and 0 consistency errors in database ‘ YourDatabaseName’. Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical …
Occasionally you may want to run DBCC CheckDB against all of the databases on your SQL Server. Hopefully you have a job to run checkdB regularly, but in case you just want to check to confirm that you have no corruption on all of your databases right now you can use this script. Once you run the script copy …
Quick script to run DBCC CheckDB for all of your databases Read more »
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were no less than amazing! We were in a major bind; we had corruption in a SQL Database and all kinds of finger pointing from my software and hardware vendors. From one of my vendors “ …
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 in with Remote Desktop. The Server Manager has a bad reputation for taking up lots of CPU over time and possibly even bogging down a SQL Server when left open for days on end. To …
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 4th year in a row. This conference will be in Seattle in November. Here is the session that was accepted. Exploring SQL Server Join Types – INNER, OUTER, and Much More Speaker: Steve Stedman Duration: 75 minutes …
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 corruption in your SQL Server Database. Then someone asks you the age old question… When will it be done? You look at the window running the command and you can see how long it …
DBCC CheckDB or CheckTable – Find percent complete Read more »
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 completely recovered and up and running. I certainly didn’t get enough sleep over the weekend, and I think that I may have set a personal record for the longest Webex session that I have participated …
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 file hierarchy like this: Database Name Type of object (proc, table, view, etc) Name of object When I go to deploy the scripts I need to manually combine all the SQL files into one to …
This confused me for a few minutes today and I wanted to share to help avoid further confusion. The specific code was this: 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