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.
SQLAuthority News – SQL Server Seminar at Colombo Full – Hyderabad Few Seats Available
If you are familiar with my blog, you might be aware of that I am doing world-wide seminar on SQL Server Seminars. I have lots of request to do the event in various cities, now our plan is very simple and to do this in very few cities. Our current…
Read MoreSQL SERVER – Get Query Running in Session
I was recently looking for syntax where I needed a query running in any particular session. I always remembered the syntax and ha d actually written it down before, but somehow it was not coming to mind quickly this time. I searched online and I ended up on my own…
Read MoreSQL SERVER – Microsoft SQL Server 2008 Service Pack 2 Download
Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for download. You can download your preferred version from link here. The major enhancements are as following: 15K partitioning Improvement. Reporting Services in SharePoint Integrated Mode. SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.…
Read MoreSQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts
Since I started the monthly round up of the blog post, I have received many positive feedback. I plan to continue doing this month refresher every month now. This rounds ups are my mirror and informs me what I have been doing whole month. Here is quick look at the…
Read MoreSQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… When I wrote the article about SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2, I had received a…
Read MoreSQLAuthority News – SQL Health Check and SQL Seminars
After announcing the SQL Seminar series and SQL Health Check series, there has been a great response from them. I already have signed up assignments until December 2010 Mid Week for doing various health checks for different organizations. One thing that I noticed is that there’s something common and popular…
Read More