When you need to shred just part of the data within a large XML file into a SQL Server table, the most efficient way is to just select what you need via XQuery or by using XPath, before shredding it into a table. But precisely how would you do that?
2013-03-28
3,174 reads
2013-03-15 (first published: 2013-02-21)
7,764 reads
When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from SQL, it is often done 'at arms length'. A shame, since effective use of techniques that go beyond the basics can save much code,
2012-11-01
3,886 reads
XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running queries against half a million XML employee records. The execution time of a query is reduced from two seconds to being too quick to measure, purely by creating the right type of secondary index for the query.
2012-10-25
2,575 reads
2012-08-01
2,125 reads
This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.
2012-03-28
4,861 reads
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
2012-03-21
3,870 reads
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
2012-03-14
18,167 reads
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
2012-03-07
7,967 reads
In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.
2012-02-07
4,207 reads
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I have a SP that finds the average based on 3 tables. ...
I have a large table with 17M+ rows for our package record audits. I've...