Viewing 4 posts - 1 through 4 (of 4 total)
Jeff, you are right!
The claim by this article that Microsoft is listening is just false. I am of the same opinion on topics you have mentioned. These were logged on...
April 27, 2021 at 6:13 pm
#3876456
Only your code runs about 16 seconds on my laptop versus less than a second for the version commented in my post, and cost 5 times more in plan costs...
October 15, 2009 at 7:12 am
#1066235
From my personal experience, parsing XML using nodes() is OK if you do not travel axes (../). You just need to write it properly.
For very huge files, OPENXML will...
October 8, 2009 at 12:43 pm
#1063668
check execution plan of the original query and this one
SELECT T.Item.value('Name[1]', 'VARCHAR(50)') Name,
T.Item.value('Salary[1]', 'INT') Salary
FROM @xml.nodes('/ROWS/ROW') AS T(Item)
August 28, 2009 at 9:01 am
#1046290