Friday, January 27, 2006 - Posts

What can SQL Server 2005 do for you

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 can SQL Server 2005 do for you
The new RSS feed is here

If you've read my previous post on performance issues with a stored procedure I thought it would be good to revisit the SP with a view of what SQL Server 2005 can do to assist. There are quite a few

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/What can SQL Server 2005 do for you

posted Friday, January 27, 2006 11:52 AM by SimonSabin with 0 Comments

Performance tuning with subqueries and parameters

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 tuning with subqueries and parameters
The new RSS feed is here

Patrick Wright has recently posted on a performance issue he was asked to look into. The issue in question involved an SP that was taking a huge amount of time, compared to what it should have been. This is one of those real life scenarios where its not a simple you need an index there are lots of factors influencing the issue.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Performance tuning with subqueries and parameters

posted Friday, January 27, 2006 6:00 AM by SimonSabin with 0 Comments