I did not hand it a plan with a spill in it. Everybody can find a spill. I handed it a plan with no warnings at all, where every number on the screen looked healthy, and the query underneath was reading five million rows to return seventeen.
Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
SQL SERVER 2022 – Parameter Sensitive Plan Optimization (PSPO)
SQL Server 2022 introduces an exciting new feature called Parameter Sensitive Plan Optimization (PSPO), which aims to improve the performance.
SQL SERVER 2022 Features for Performance Optimization
I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.
SQL SERVER – Parameter Sniffing and Bad Plan
Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
SQL SERVER – Multiple Optimize Hint for a Query
An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.
What is Stored in TempDB? – Interview Question of the Week #271
Question: What is Stored in TempDB?
Answer: In my recent conversation my client asked me if I know what is currently stored in their TempDb.