In one of my recent Performance Tuning assignment I was asked how do someone know how many transactions are happening on server during certain interval. I had handy script for the same. Following script displays transactions happened on server at the interval of one minute. You can change the WAITFOR DELAY to any other interval and it should work.
SQL SERVER – The Limitations of the Views – Eleven and more…
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.