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 – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
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 – SELECT * and Adding Column Issue in View – Limitation of the View 4
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
Update: Please read the summary post of all the 11 Limitation of the view SQL SERVER – The Limitations of the Views – Eleven and more… Let us learn about Index Created on View not Used Often.
SQLAuthority News – A Monthly Roundups of SQLAuthority Blog Posts – Updated 2019
Monthly roundups are very refreshing as it gives me a chance to go back and see what did I do last month. Let us learn in this blog post.
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.
SQL SERVER – Does Order of Column in WHERE Clause Matter?
Today is a quick puzzle time. Let us learn about – Does the order of column used in WHERE clause matter for performance? Let us learn today.