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 ...