I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.
Sharing an Execution Plan Without Exposing Sensitive Data
Protect sensitive data when sharing an execution plan by inspecting XML values, redacting names and literals, and checking the file again.
XML Compression in SQL Server 2022
Use XML compression in SQL Server 2022 to reduce XML storage, inspect partition settings, and compare CPU costs on your own workload.
XQuery distinct-values: Deduplicate Atomic Values, Not Nodes
XQuery distinct-values removes repeated atomic values rather than selecting representative source nodes. I rebuild a small sorted XML result from repeated text. The example also keeps an empty document in view.
XQuery FLWOR: Filter and Rebuild a Small XML Result
XQuery FLWOR can iterate over source items and construct a different XML result. I use it to filter three products and reorder the survivors. The new elements deliberately differ from the source elements.
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
Msg 9514 means a distributed query touched an XML column. Why the type cannot cross a linked server, and four ways to get the data across anyway.