A Little About Local Variables In SQL Server скачать в хорошем качестве

A Little About Local Variables In SQL Server

In this video, I delve into the intricacies of local variables in SQL Server and how they differ from parameters and literal values. I explore their unique behavior through detailed examples, including a store procedure that demonstrates why using local variables to address parameter sniffing issues is not only ineffective but also leads to suboptimal query plans. By walking you through these scenarios, I aim to clarify the misconceptions surrounding local variables and offer practical advice on how to handle them more effectively in your SQL Server code. CHAPTERS 00:00:00 - Introduction 00:00:29 - Bitly Link Warning 00:01:28 - Index Leading Key Column 00:01:33 - No 3D Chess Stats 00:01:46 - Statistics in SQL Server 00:02:15 - Local Variables vs Parameters 00:03:07 - Parameter Sniffing Example 00:03:32 - Bad Guesses and Plan Choices 00:04:43 - Valid Use Case for Local Variables 00:05:40 - Store Procedure Example 00:06:31 - Dynamic SQL with Local Variable 00:07:35 - Correct Number of Rows 00:08:01 - Fixing Parameter Sniffing 00:09:03 - Parameter Sniffing Issues ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━