Brent Ozar shares some thoughts from the first day’s keynote from SQLBits:
Pedro Lopes took the stage to talk about parameter-sensitive plan optimization, aka PSP Optimization. He demoed it with SQL Server 2022 CTP 1.3. I’ve written about this feature before, and there wasn’t anything new here in the demos. My opinion on this feature remains the same: I think it sounds like a phenomenal down payment. It won’t fix parameter sniffing, but I don’t think it’s going to backfire.
Read on for Brent’s thoughts around what Microsoft is doing for SQL Server 2022.