To clear the plan cache for one database, use ALTER DATABASE SCOPED CONFIGURATION CLEAR PROCEDURE_CACHE in that database. This post tests it on two small databases, compares it with DBCC FLUSHPROCINDB and with freeing a single plan, and explains why DBCC FREEPROCCACHE is a bad habit.
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
When should you use sort_in_tempdb for rebuilding indexes? A DBA asked me in a Health Check, and the simple answer is when TempDB sits on fast, separate drives.
SQL SERVER – Cannot Shrink Log File 2 (SQLAuthorityDB_log) Because the Logical Log File Located at the End of the File is in Use
Diagnose a cannot shrink log file message with read-only SQL, active VLF checks and log reuse waits. Keep backup protection and size for the workload.
SQL SERVER – Which Settings Change in sp_configure Needs Restart to Take Effect?
Which settings changed in sp_configure need a restart to take effect? You do not need to remember them, because a catalog view added in SQL Server 2008 tells you.
SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed
A client’s second clustered SQL Server instance failed to install: Specified instance via transform is already installed. Here is what I found and the fix.
How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206
How do you sort a Varchar column storing integers with Order By when you cannot change the datatype? Here are two simple solutions I shared with a developer.






