Tag Info

New answers tagged

2

It seems that when setting the directive (the 4th item in the !-delimited specification that is the field name alias) to "element", then the 3rd item in that specification is the element name that contains the value, whereas the 3rd item would otherwise be the attribute name that contains the value. In both cases the 1st item in the specification is the ...


3

I had another look at this and can reproduce your issue. Try adding OPTION ( MAXDOP 1 ) to your query. In my test rig with a 300MB file this ran in 1 min 42 seconds. The unhinted version ran for 30 minutes at 100% CPU before I killed it. You could also have a look at OPENXML. People often say it's faster with large XML files and it appears to be in this ...


0

I am doing a lot of work with BLObs, typically ~2MB each. If I do an SQL query and limit the number of rows returned by a simple 'WHERE ID > x AND ID < y' the time of the query is not linearly related to the number of rows returned. What I found looking at the System Monitor was that the memory used increased as time passed thus I surmise increasing the ...



Top 50 recent answers are included