HowardW (7/28/2014)
I think you'd still have a 2GB max size that you can manipulate through XQuery, wouldn't you?
The way around it is to work with the XML in smaller parts as normally an XML of this size breaks down into sub nodes of a reasonable size. For instance, if the XML file contains a list of locations, one can normally reconstruct each location element. The good thing about the XML data type is that the content doesn't have to be well formed, i.e. doesn't matter if the root node is missing.
😎