Yearly Archive: 2008

Pushing for more disclosure in DMVs

I have been involved in several discussions over the past week involving getting more diagnostic information out of the DMVs in SQL Server 2008 and beyond. Yesterday, I asked for procedure recompiles to be...

SQL Quiz : Career Challenges

I was tagged by Denis Gobo to write a bog post about career challenges and how I overcame them.  I'm not going to tag anyone else because I can't seem to find anyone that...

CU2 for SQL Server 2008 is missing!

UPDATE 2008-12-03 The download packages for the database engine have returned to the download page.  Make sure you download the file labeled "SQL_Server_2008_Cumulative_Update_2" to apply to machines where the SQL Server engine is present,...

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

Is SQL Server "keeping up" with MySQL?

I read a comment in a Connect suggestion today that implied that implementing their suggestion would allow SQL Server to "keep up with MySql."  Regardless of the actual suggestion, that made me laugh out...