mister.magoo (2/13/2013)
this version packs 70,000 requests in about 13 seconds on my desktop.
Debug version SQLCLR procedure (without bulk copy) loading the destination table: 1.4s on the same data set.
Time to return the 70,304 result rows to the SSMS grid: 750ms.
CLR cursors: priceless 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi