The MATCH clause finds rows in SQL Server graph tables by describing the path between them. The small graph runs one hop, two hops, a shared skill and a SHORTEST_PATH query, compares the plain join, and shows what the MATCH clause does not allow.
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.
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?
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 – 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.
Temporal Table Retention: Cleaning Out Old History Automatically
Set temporal table retention, check history cleanup settings, and choose a history index that lets old versions leave safely.