Learn T-SQL With Erik: Inline Table Valued Functions скачать в хорошем качестве

Learn T-SQL With Erik: Inline Table Valued Functions

In this video, I dive into the world of inline table-valued functions in SQL Server and explain why they might be a better choice than scalar or multi-statement table-valued functions for performance-sensitive queries. I discuss how these functions are essentially just parameterized views, making them easier to optimize and less prone to the same performance issues as their counterparts. By exploring examples and comparing inline table-valued functions with scalar UDFs, I highlight the benefits of inlining, such as reduced execution plan overhead and more accurate cost estimates. Additionally, I touch on upcoming speaking engagements, including trips to Dallas, Utrecht, and Seattle, where I'll be sharing more insights into SQL Server performance tuning. CHAPTERS 00:00:00 - Introduction 00:02:15 - Inline Table-Valued Functions Overview 00:05:36 - Comparison with Scalar UDFs 00:08:45 - Execution Plan Differences 00:10:24 - Recommendations and Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━