A reader with only MDF files and no backups got a CollationID from DBCC CHECKPRIMARYFILE. Here is how to convert that CollationID to a Collation Name.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Build Three Part Name from Object_ID? – Interview Question of the Week #134
If you only have an object_id, can you get the database, schema and object name? Here is a simple script that builds the Three Part Name from Object_ID.
SQL SERVER – FIX: The Log for Database Cannot be Shrunk Until All Secondaries Have Moved Past the Point Where the Log was Added
Shrinking a bloated AlwaysOn log gave me: the log cannot be shrunk until All Secondaries have moved past the point where the log was added. Here is the fix.
SQL SERVER – Caution: Adding Node in AlwaysOn Availability Group
Three clients hit the same issue after adding node at a DR site to an AlwaysOn cluster: disks on the original servers went offline. Here is what to watch for.
Auto-Created Statistics: What the _WA_Sys Names Tell You
Read auto-created statistics through sys.stats and sys.stats_columns, then use their columns as clues for better query tuning.
SQL SERVER – How to Abort Index Rebuilding After Specific Time?
An index rebuilding limit can control lock waiting or a resumable execution interval. I decide which behavior the maintenance window needs.
SQL SERVER – Automatic Startup Not Working for SQL Server Service
After a power failure, a client’s SQL Server service stayed down even though it was set to Automatic. Here is why automatic startup can fail and what to check.
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.