Tuesday, May 16, 2006 - Posts

Performance of MAX trick

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Performance of MAX trick
The new RSS feed is here

Jamie posted a comment to by post about the trick for finding a maximum value in a set of results. Stating that the CASE statement solution was significantly faster. Being a synic I didn't believe him so tried it out for myself

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance of MAX trick

posted Tuesday, May 16, 2006 8:15 AM by SimonSabin with 1 Comments

SQL Server Scale out architecture

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SQL Server Scale out architecture
The new RSS feed is here

There is a new article on the MSDN solution centre about the options for scaling out a SQL Server Architecture.

Its a very good read and a must for anyone loooking into scaling out their infrastructure.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SQL Server Scale out architecture

posted Tuesday, May 16, 2006 5:13 AM by SimonSabin with 0 Comments

Most annoying errors in SSIS

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Most annoying errors in SSIS
The new RSS feed is here

What is the most annoying error that you have/are encountering with SSIS?

The documentation team for SSIS are looking to document the most common errors, their causes and the solutions. If you have any then post a comment below or use the contact me on the left and I will forward it on.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Most annoying errors in SSIS

posted Tuesday, May 16, 2006 3:04 AM by SimonSabin with 1 Comments