O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

What’s New in Using XML in SQL Server 2012

The release of SQL Server 2012 includes a variety of significant XML feature and behavior changes, including the following:

Image Introduction of the Selective XML Index (SXI), a highly efficient storage and lookup mechanism that brings huge increases in speed and flexibility and big decreases in storage requirements. (SXIs are covered in depth in this chapter in the section, “Indexing and Full-Text Indexing of xml Columns.”)

Image A behavior change to the exist() xml data type method when comparing NULL values (covered ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required