SQL Server 2017 CU 30 Doesn't Actually Fix The Problem With Views And Parameters
In this video, I dive into SQL Server 2017 CU30 and highlight a specific performance improvement that caught my attention. While the update isn't filled with groundbreaking features, it does address an issue related to parameterized queries skipping the sell-on seek purge rule, which has been a known problem for years. I walk through how this fix works when running simple queries but then demonstrate the disappointing reality of the same behavior persisting in stored procedures, despite the documentation suggesting otherwise. The video showcases the frustration that comes with trying to find clear and accurate information about software fixes, especially when new error messages or extended events are introduced without proper oversight or clarity.
CHAPTERS
00:00:00 - Introduction to the Shield and Philosopher's Blessing
00:01:25 - The Problem with Parameterization in Cumulative Updates
00:03:46 - Simple Parameterization Works Well
00:05:37 - Creating a Stored Procedure for Parameterized Query
00:08:09 - Running the Parameterized Query and Disappointing Results
00:10:21 - QA and Release Notes Critique
00:10:59 - Conclusion and Tagline
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━