A co-worker analyzed CTE performance in SQL Server 2005 and determined it begins to degrade after, if I recall, 100,000 records.

As we encounter performance related issues in production which involve...

We recently encountered the same issue in multiple production db's.

When re-inserting the data back in use BULK INSERT and remove the indexes, it is significantly faster.

Your batch count is really small. I would try at least 10k.

declare

@STR nvarchar(max)

,@p1 int

set @STR = '/Folder/File/Name'

select @p1 = charindex('/', reverse(@str)) - 1

select right(@str, @p1)

I've reviewed some information from a few of the sites.

I assume some are better than others.