Monthly Archive: July 2008

Performance Advisor : A Quick "Two Thumbs Up"

I have been playing with Performance Advisor, the new companion to the very popular Event Manager software from SQL Sentry.  Right off the bat, I can tell you that this tool should have Quest...

Very important SQL Server update

There is a patch available for four elevation of privilege vulnerabilities recently discovered in SQL Server. From http://www.microsoft.com/technet/security/bulletin/ms08-Jul.mspx: This security update resolves four privately disclosed vulnerabilities. The more serious of the vulnerabilities could allow...

A little Management Studio "oops"

For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of...

sys.dm_exec_requests

One of the dynamic management views (DMVs) that is very useful in troubleshooting query performance is sys.dm_exec_requests.  The documentation around this DMV, however, is quite lacking in two areas. percent_complete This column shows the...