I earlier wrote interesting article series on the limitations of the views. I had great time writing this series. I got many many request to write more on the subject but honestly, I think I gave my best to the subject.
I am now interested to read what all of you have to offer on this subject. I encourage all of you to go through complete series and write your own on the subject. If you write an article and send it to me, I will publish it on this blog with due credit to you. If you write on your own blog, I will update this blog post pointing to your blog post.
Limited View
- SQL SERVER – ORDER BY Does Not Work – Limitation of the View 1
- SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the View 2
- SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
- SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
- SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5
- SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6
- SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7
- SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8
- SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
- SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
- SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
Reference: Pinal Dave (http://blog.SQLAuthority.com)
[...] If you are interested in reading more about Views here is my quick blog post which discusses my recent articles on limitations of the views. [...]
[...] have been recently writing about Views and their Limitations. While writing article series I got inspiration regarding SQL Server Quiz Questions. You can view [...]
[...] earlier article SQL SERVER – The Limitations of the Views – Eleven and more… has lots of popularity and I have been asked many questions on the view. Many emails I received [...]
Hey pinal here one more limitation of the Indexed View
I got the error while createing IV from synonyms.
Error : -Msg 2788, Level 16, State 1, Procedure U_ALLOBJECT, Line 4
Synonyms are invalid in a schemabound object or a constraint expression.
[...] Additionally, if above problem interest you, I suggest you read my article series on limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… [...]
[...] have previously written on the subject SQL SERVER – The Limitations of the Views – Eleven and more…. This was indeed a very popular series and I had received lots of feedback on that topic. Today we [...]
[...] I always enjoy writing about concepts on Views. Views are frequently used concepts, and so it’s not surprising that I have seen so many misconceptions about this subject. To clear such misconceptions, I have previously written the article SQL SERVER – The Limitations of the Views – Eleven and more…. [...]
[...] If you have been reading my blog, I am sure you are aware of my series related to SQL Server Views SQL SERVER – The Limitations of the Views – Eleven and more…. With this, I can take a quick look and figure out how many times Views were used in various [...]
[...] Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… [...]
[...] Server Interview Questions and Answers ISBN: 1466405643 Page#50 The Limitations of the Views – Eleven and more… Interesting Observation – Index on Index View Used in Similar Query Outer Join Not Allowed in [...]
read all articles..informative. thanks!
GReat pinal sir…………………….
Most of this limitations are connected with indexed views.
can we use set like
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
in views ??