I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.