Tag: XML data type

Pro Members SQL Server Standard Members

Some tips for designing SQL Server 2016 tables (Part 2)

by

Some tips for designing SQL Server 2016 tables (Part 2) Try to reduce the number of columns in a table. The fewer the number of columns in a table, the less space the table will use, since more rows will fit on a single data page, and less I/O overhead will be required to access the table’s data. Consider using...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Tips for using XML in SQL Server 2016

by

Tips for using XML in SQL Server 2016 Consider using the RAW mode of FOR XML queries, instead of AUTO or EXPLICIT modes. The RAW mode transforms each row in the result set into an XML element with a generic identifier as the element tag. Using this mode provides the best overall performance, in comparison with the AUTO and EXPLICIT […]

Continue Reading →
Pro Members Standard Members XML

XML Support and SQL Server (Part 4)

by

XML Support and SQL Server (Part 4) By Basit A. Farooq Editor’s Note: This article is the fourth part of my XML support and SQL Server article series. In this part, I’ll talk about XML data type. I’ll also demonstrate how you can create XML variables and XML columns, and compare between typed and untyped XML. With the release of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →