Wednesday, April 04, 2007 - Posts

ProClarity 6.3 available on MSDN downloads

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/ProClarity 6.3 available on MSDN downloads
The new RSS feed is here

I've just logged into MSDN downloads and was very shocked to see ProClarity available for download.

Both server and desktop versions are available.

You can read more on Proclarity here

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/ProClarity 6.3 available on MSDN downloads

posted Wednesday, April 04, 2007 11:28 PM by SimonSabin with 0 Comments

How to alert on system errors

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How to alert on system errors
The new RSS feed is here

Alerts in SQL server rely on the error being logged to the event log. Not all system messages are logged which means you can't alert on them. In SQL 2000 you could hack the sysmessages table, however in SQL2005 you can't.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How to alert on system errors

posted Wednesday, April 04, 2007 1:38 PM by SimonSabin with 0 Comments

What is the cost of a query? Is it a beard?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/What is the cost of a query? Is it a beard?
The new RSS feed is here

I used to work on a project where we discussed what exactly the cost of a query was. You know that figured shown in execution plans. I knew it was used to age plans in a cache but not sure what unit it actually was. One of the guys on the project (Mike I think) decided to call them "Beards". So we could then say that query x cost 54 beards. Its feels better than saying just 50.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/What is the cost of a query? Is it a beard?

posted Wednesday, April 04, 2007 9:15 AM by SimonSabin with 0 Comments