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.
Multi-Statement Table-Valued Functions and Interleaved Execution
See how interleaved execution corrects estimates for multi-statement table-valued functions and when an inline rewrite wins.
Puzzle – Datatime to DateTime2 Conversation in SQL Server 2017
At PASS, SQL Server expert Christopher Savage showed me a puzzle on DateTime to DateTime2 conversion in SQL Server 2017. I still have no answer, so can you solve it?
SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events
With Extended Events, you can identify all the deprecated SQL Server features your code still uses. It is very handy before you change compatibility level.
Automatic Plan Correction: Reading SQL Server’s Tuning Advice
Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.
SQL SERVER – 2017 – Script to Clear Procedure Cache at Database Level
I usually say no when customers ask to clear the cache. If you must, here is how to Clear Procedure Cache at database level in SQL Server 2017.
SQL SERVER – Identity Jumping 1000 – IDENTITY_CACHE
Has your identity column ever jumped by 1000 after a restart? SQL Server 2017 fixes it with IDENTITY_CACHE. Here is a demo with the setting ON and OFF.