SQL Server 2008 - TSQL behavioural changes and enhancements
As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should be used extensively with inter-dependnt constructions such as BEGIN...END with a logical conditions. Also the queries on the partitioned tables and indexes have been changed such as to get performance with a USE PLAN hint generation.
Such as there are many more to find out, recently I have found this excellent article by fellow [SSP] moderator & member 'Dinesh Asanka' about TSQLEnhancements-SQL2008 subject, check it out.