Rin Sitah replied to my interview question with a neat alternative way to build three part name from Object_ID using sys.objects and sys.schemas.
SQL SERVER – How to Convert CollationID to Collation Name?
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.
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.