PiMané (1/16/2013)
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
Definitely interesting. Looks to me like you can go with OpenXML in this case.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon