I have recently written many articles on the limitation of the views. I have tried to sum up all the keywords which are not allowed in the indexed view.
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Previously, I wrote an article about SQL SERVER – The Self Join – Inner Join and Outer Join, and that blog post seems very…
Read MoreSQL SERVER – Get Numeric Value From Alpha Numeric String – Get Numbers Only
I have earlier wrote article about SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only and it was very handy tool for me. Recently blog reader and SQL Expert Christofer has left excellent improvement to this logic. Here is his contribution. He…
Read MoreSQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… This blog post was previously published over here. I am republishing it in the series Limitation of the Views with a few modifications. While…
Read MoreSQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… One of the requirements of Indexed View is that it has to be created ‘WITH SCHEMABINDING’. If the View is not created with that…
Read MoreSQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… If you want to create an Indexed View, you ought to know that UNION Operation is not allowed in Indexed View. It is quite surprising…
Read MoreSQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. In…
Read More