How do you move SQL Server MDF and LDF files? Detach and attach is the old way, so here is the step-by-step method I use for my clients today.
SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String – Number Table Method
I rewrote my User Defined Function to extract only numbers from a string. The new one uses a numbers table, also called a Tally table, instead of a WHILE loop.
SQL SERVER – Unable to Attach Database Files – The PageAudit Property is Incorrect – Ransomware Attack
After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.
SQL SERVER- High CPU and Transaction Type WorkFileGroup_fake_worktable and Workfile
Workfile and WorkFileGroup_fake_worktable were clues in a customer high-CPU investigation. I correlated them with queries and plan evidence.
SQL SERVER – How to DROP or DELETE Suspect Database?
A client’s production database was stuck in suspect state and they could not even drop it. Here is how I helped them drop the suspect database.
What Part of the SQLDump Suggest Database Corruption? – Interview Question of the Week #188
What part of the SQLDump suggest database corruption? A reader asked, and I show the DbccResults tag in the SQLDump text file that confirms it.
Msg 5123: CREATE FILE Access Denied on TempDB After Disk Migration
Msg 5123 with operating system error 5, Access is denied, kept SQL Server from starting on a cluster after a disk migration. TempDB files could not be created on the new drive. Giving the SQL Server service account Full Control on the folders fixes it.