I can Clear Plan Cache for the current database through database-scoped configuration. I verify the context before considering eviction.
SPID, KPID and ECID in sys.sysprocesses: What They Mean
SPID, KPID and ECID are the three ID columns of sys.sysprocesses: the session, the Windows thread and the part of a parallel query. This post reads them for an idle session and for a query running in parallel, explains why KPID can be negative, and names the DMVs that give the same answers today.
SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?
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.
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.
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.