Thank you so much for this very informative article.
I have been trying to analyze the windows registry with SQL Server and found some lines to be over 60 thousand characters long!
I would like to chop the long lines into 2000 character segments and put it into a new table with the original rowID, segmentID, and the 2000 characters in a varchar field.
With what you've shown I think it will work.
Thanks so much!!