What started as a simple recommendation turned into a comprehensive benchmarking exercise. Let us see blog post about JSON vs XML.
Optimizer Timeouts: Reason for Early Termination in a Plan
Diagnose optimizer early termination in SQL Server plans, find cached timeouts with XML, and simplify queries using measured evidence.
Capturing Actual Execution Plans From a Script With SET STATISTICS XML
Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.
SQL Server Integration Services (SSIS) – There Was an Exception While Loading Script Task from XML
An SSIS package ran fine in Visual Studio but failed as a SQL Agent job: There was an exception while loading Script Task from XML. Here is why and the fix.
SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries
Querying a table with an XML column over a linked server fails with Msg 9514: XML data type is not supported in distributed queries. Here is the fix.
SQL SERVER – XML Document Could Not be Created Because Server Memory is Low. Use sp_xml_removedocument to release XML documents
XML document could not be created, error 6624, on a server with 300 GB free. What OPENXML really costs, measured, and why XQuery is the fix.
SQL SERVER – System. Security. Cryptography. CryptographicException – There Was an Error Generating the XML Document
SQL Server setup failed with an error generating the XML document. The real cause was DPAPI and a read-only domain controller, found in Summary.txt.