Thursday, March 02, 2006 - Posts

SSIS File handle leak in For Each Loop

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS File handle leak in For Each Loop
The new RSS feed is here

There has been a post on the forums recently mentioning an issue with looping and file handles being leaked in Integration Services.

The post can be found here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=277765&SiteID=1

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS File handle leak in For Each Loop

posted Thursday, March 02, 2006 6:32 PM by SimonSabin with 0 Comments

Increase the performance of updates by 1000

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Increase the performance of updates by 1000
The new RSS feed is here

Following on from my previous post on varchar(max) for which the consensus was that one shouldn't use varchar(max) everywhere, I have found this great function that allows you to update a varchar(max) column with great performance gain.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Increase the performance of updates by 1000

posted Thursday, March 02, 2006 6:51 AM by SimonSabin with 2 Comments