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 – 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 MoreSQL SERVER – Disabled Index and Index Levels and B-Tree
This blog post is written in response to T-SQL Tuesday hosted by Michael J. Swart. Recently, I presented a session at the Microsoft Bangalore office. Everybody eagerly wanted to learn more, to the extent that they wanted a mentor to train each of them in order to move on to…
Read MoreSQL SERVER – Index Levels and Delete Operations – Page Level Observation
I wrote an article before on SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats. In that article, I promised that I would give a follow up post with a few more interesting details. I suggest that you go over the earlier article first to understand…
Read MoreSQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…
Read More