Msg 0, Level 11 says a severe error occurred but gives no clue how to fix it. Here is my checklist, starting with DBCC CHECKDB on the database and table.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Longest Streak of Consecutive Days in T-SQL: Gaps and Islands
Find the longest streak of consecutive days in T-SQL with gaps and islands: group dates with ROW_NUMBER, handle duplicates, and list gaps.
SQL SERVER – SQL Express Installation Error – Wait on the Database Engine Recovery Handle Failed
A vendor’s installer failed because SQL Express would not install: Wait on the Database Engine recovery handle failed. Here is what the setup logs showed.
SQL SERVER – Adding New Database to AlwaysOn Replica is Slow
A client with five replicas said adding a new database to their AlwaysOn Replica setup was slow. Here is what we found while the issue was happening.
How to Auto Start SQL Server After a Crash
To auto start SQL Server after a crash, set the Windows service to restart itself on failure, and set its start mode to Automatic for a reboot. This post checks what a server has today with T-SQL and the sc command, sets the three places that matter, and shows how to find the cause of the crash. A restart gets the server running again, and it doesn’t find the cause.
SQL SERVER – How to Remove TempDB File?
A DBA accidentally added an extra TempDB file and was not allowed to use SSMS to undo it. Here is how to remove a TempDB file with T-SQL only.
Mirrored Database: Move Files Without Breaking Mirroring
To move the files of a mirrored database, change the file paths on the principal with ALTER DATABASE, stop both instances, move the files, and start them again in the right order. This post tests the T-SQL steps on a demo database and describes the mirroring steps from the documented behavior. It also covers what to check afterward.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.