Scary Scalar Functions - Part Two: Performance
A Scalar function that does literally nothing still runs over 20 times slower. Here is the proof, measured four different ways.
Query Store
3 posts
Query Hash and Query Plan Hash Mapping
Ever struggled to match the binary hash from DMVs and Query Store against the numeric one in Extended Events? Let's fix that for good.
Query Store default settings
Query Store comes with default settings - but are they what the documentation says? Let's find out using a simple Extended Events session.