Clear procedure cache at the narrowest useful scope, remove one plan handle, and compare sp_recompile with statement recompilation.
SQL Authority News – 100 Million Views and Onwards
On August 20, 2015 SQLAuthority.com crossed 100 Million Views. A short thank you note to every reader who made this journey since 2006 possible.
SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions
Running DBCC CHECKDB on ResourceDB returns Msg 2520. I explain why CHECKDB cannot run on the hidden resource database and what you can do instead.
SQL SERVER – Rewriting Database History – Notes from the Field #094
Kevin Hazzard tells the story of rewriting database history, a journey that starts and ends with ORM, in Notes from the Field #094.
SQL SERVER – Login failed for user . Reason: Token-based server access validation failed
Login failed for user. Reason: Token-based server access validation failed. Here is how the state of error 18456 in the ERRORLOG shows the cause and fix.
SQL SERVER – How to Migrate Existing Database to Contained Databases
How do you convert an existing database to contained databases? I walk through the planning and use the DMV and XEvent that flag containment breaches.
SQL SERVER – PowerShell – Knowing SQL Server Information
A PowerShell script that reads SQL Server information from my localhost using SMO and writes it to a simple HTML page you can open in any browser.