SQL Server Performance Office Hours Episode 21

In this video, I dive into a series of user-submitted questions during our office hours session. We tackle topics ranging from complex T-SQL rewrites to simplifying technical concepts for broader audiences. You'll hear about my experiences rewriting entire applications and the most effective query tuning tricks I've found, like leveraging batch mode in SQL Server. Additionally, we discuss the intricacies of using stored procedure names versus text in Query Store searches and explore the downsides of dropping and recreating procedures during database updates. Lastly, I share my thoughts on what's new in SQL Server 2025, or rather, why there isn't much compelling content to talk about given Microsoft's recent focus on other areas like Fabric. Whether you're a seasoned DBA or just starting out, these insights should provide valuable information and perhaps even spark some discussion of your own.

CHAPTERS

00:00:00 - Introduction and Overview
00:02:35 - Top 5 Tips for SQL Server Performance
00:04:48 - SP Quickie Store and Human Events Block Viewer Updates
00:07:19 - Parameterized Queries and Query Plans
00:09:46 - SQL Server 2025 Features and My Thoughts
00:13:04 - Conclusion and Future Content

━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING

Learn T-SQL with Erik
https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL

Everything Bundle:
https://training.erikdarling.com/?coupon=SPRINGCLEANING

━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting

━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
https://www.youtube.com/@ErikDarlingData/join
━━━━━━━━━━━━━━━━━━━━━━━━━━

Видео SQL Server Performance Office Hours Episode 21 канала Erik Darling (Erik Darling Data)