Be Careful When You Alter Indexed Views скачать в хорошем качестве

Be Careful When You Alter Indexed Views

In this video, I dive into the quirky behavior of indexed views in SQL Server, particularly focusing on what happens when you alter an index view. I share a humorous and practical example where creating or altering an indexed view drops any indexes that were previously created on it. This can be both surprising and potentially problematic for those managing large datasets with complex queries. With my six-year-old daughter's newfound interest in YouTube, I hope to keep her entertained while also providing useful insights for fellow database administrators and developers who might encounter similar issues. CHAPTERS 00:00:00 - Introduction 00:00:32 - My Name and Role 00:00:59 - Indexed Views Overview 00:01:29 - Rules for Index Views 00:02:13 - Creating an Index View 00:02:43 - Dropping the Index 00:03:02 - Moral of the Story 00:03:38 - Summary 00:04:01 - 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   ━━━━━━━━━━━━━━━━━━━━━━━━━━