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.
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.
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.
CPU-Bound Queries: Comparing worker_time to elapsed_time
Is a slow query working or waiting? Compare its two clocks and you will know what to fix before anyone buys more CPU.