SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book intotheSQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

A new trainee was confused when he discovered that the organization is discouraging the Indexed View (or materialized views). After talking to the senior team members he realized that Index Views which are good at certain tasks it comes with lots of restrictions. What are the restrictions of using INDEXED VIEWS inside SQL Server?

Notes of Vinod Kumar

Not that I am a great supporter of using INDEXED VIEWS, but there are obviously some special case scenarios. This Hint gives some amazing documentation around its usage.

Notes of Pinal Dave

As far as I can remember, Views are one of the very old concepts. Earlier in my career, around year 2000, Views were extremely useful to me. I used to rely on them for many reasons – preventing access to the data to users, hiding table definition from users, creating modular T-SQL logic, using materialized views for performance, you name it. However, I gradually started to use stored procedures and user access security features leading less and less use Views. However, I sometimes use Index Views for special cases until now. And these special cases are what exactly we should learn today.

Community Initiatives

About Pinal Dave

Pinal Dave is a Pluralsight Developer Evangelist. He has authored 11 SQL Server database books, 17 Pluralsight courses and have written over 3200 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 11+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Follow @pinaldave
Send Author Pinal Dave
an email at pinal@sqlauthority.com

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.