GSquared (1/16/2013)
From what I recal, it is expensive that way. Can cause SQL Server to page-out RAM to disk. It's been years since I used it, so I could be misremembering the details. Do you have a test environment that you can safely overload that way?
I used SqlQueryStress with 5 iterations and 10 threads and got no error... And the times were as expected..
Nodes() is faster with less columns but OPENXML is way faster with more columns... Funny that it doesn't matter the columns defined on the WITH clause from OPENXML (always defined all in both cases), it only matters the columns on the SELECT output...
Sent an image with the results....
Thanks,
Pedro