O'Reilly logo

SQL Server Execution Plans, 2nd Edition by Grant Fritchey

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

Chapter 7: Special Datatypes and Execution Plans

The introduction of the Common Language Runtime (CLR), and with it the ability to run .NET code within SQL Server, may not have taken the database world by storm, but Microsoft has certainly started to put it to work. It has exploited the capabilities introduced with CLR to add a lot more functionality to SQL Server, through the addition of special data types.

In addition to the special functionality around XML, available since SQL Server 2005, SQL Server 2008 saw the introduction of the spatial data type and the hierarchy data type, to name just a couple, and more will be coming with new releases of SQL Server.

Some of these data types have no effect on execution plans, while others have a major ...

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