A Little About Computed Columns, Filtered Indexes, and Indexed Views in SQL Server скачать в хорошем качестве

A Little About Computed Columns, Filtered Indexes, and Indexed Views in SQL Server

In this video, I delve into the intriguing world of indexed views in SQL Server and how they can be used to circumvent some of the limitations associated with computed columns and indexes. I share my experience from a previous attempt where my voice sounded like it had just emerged from a crypt, which led me to create this video as a second take for clarity and engagement. We explore why you can't create filtered indexes on computed columns or indexed views, and how using an indexed view with the filter expression incorporated in its definition can help achieve our desired outcome. I also discuss the practical implications of these limitations, particularly for standard edition users, and highlight the importance of including the 'NOEXPAND' hint to ensure that SQL Server uses the index view efficiently. CHAPTERS 00:00:00 - Introduction 00:02:36 - Computed Columns and Filtered Indexes 00:04:47 - Index Views and Their Limitations 00:08:15 - Using Filters with Index Views 00:10:19 - Importance of the NOEXPAND Hint 00:12:31 - Columnstore Indexes and Enterprise Edition Considerations 00:14:05 - SQL Server's Current State and Future Prospects 00:15:04 - Call with a Client and Consulting Services ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━