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

A Little About Computed Columns In SQL Server

In this video, I delve into the challenges of using expressions within SQL Server queries and how they can impact query performance. Specifically, I explore why SQL Server cannot use indexes on calculated expressions to seek data efficiently. By walking through a practical example involving Stack Overflow user data, I demonstrate that while creating an index on the columns involved in the expression might not always yield significant improvements, using a computed column can help SQL Server better utilize missing index suggestions and improve query performance. Throughout the video, I also address some humorous personal anecdotes about my vocal settings and even make a plea for regional number formatting improvements in SQL Server Management Studio to enhance readability. CHAPTERS 00:00:00 - Introduction 00:01:37 - Expressions and Indexes 00:03:18 - Clustered Index Scan 00:05:09 - Filtered Index Attempt 00:06:42 - Computed Column Solution 00:08:45 - Expression Matching 00:10:54 - 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━