Question: How to clear plan cache with Database Scoped Configuration? In SQL Server 2016 and later, one T-SQL command clears the plans for one database.
SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes
During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.
SQL SERVER – How to Change Database Compatibility Level?
After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
SQL SERVER – Jump in Identity Column After Restart
A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.
SQL SERVER – Script Upgrade – Server Principal ‘MS_PolicyEventProcessingLogin’ Has Granted One or More Permission(s)
SQL Server would not start after patching: Script Upgrade failed because ##MS_PolicyEventProcessingLogin## had been granted permissions. Here is the fix.
SQL SERVER – SQL Browser not Starting. Error – The SQL Configuration for SQL is Inaccessible or Invalid
After server hardening, SQL Browser would not start and the event log said the SQL configuration for SQL is inaccessible or invalid. Here is the fix.
Why to Use SQL Server Configuration Manager Over Services applet (services.msc)? – Interview Question of the Week #112
Why use SQL Server Configuration Manager Over Services applet (services.msc) to change a service account? The reasons, from permissions to passwords.