Monthly Archive: July 2008

How do the links in YOUR copy of SQL Server 2008 Books Online work?

How do the links in YOUR copy of SQL Server 2008 Books Online work?

I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.) I have had...

Performance Advisor : A Quick "Two Thumbs Up"

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

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"

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

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...