I had earlier written, interesting article series on the limitations of the views. I had a great time writing this series. I got many many requests.
SQL SERVER – Get Query Running in Session
I forgot the simple syntax to get query running in session and ended up on my own old post. Here is the one method I use most during performance tuning.
What a Cumulative Update Actually Contains
Understand a SQL Server cumulative update, identify your build and servicing branch, and read fixes and known issues before planning a patch.
Shredding sp_server_diagnostics Output Into Health Rows
Check shredding sp_server_diagnostics with SQL Server examples, practical queries, clear limits, and steps to verify your own database.
SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
Why can’t you create a view over the view and index it? An index view cannot reference another view. Limitation of the view 11 shows an example.
SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
A quick reference of the keywords a view definition must not contain if you want an indexed view in SQL Server, part 10 of my views series.
SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
Self Join is handy, but it is not allowed in indexed view definitions. Limitation of the view 9 reuses my employee and manager example to show it.