In case you missed Greg post about Yukon T-SQL enhancements, MSDN just made available tha White Paper that Itzik Ben-Gan wrote for Solid Quality Learning to be part of the SQL Server Yukon Beta 1 Readiness Kit.
Itzik co-presented a session on this topic with Lubor Kollar at the SQL Server Summer Academy in Dubrovnik last summer, and it still amazes me how much great stuff this guy can do.
You can read some of his articles at SQL Server Magazine too.
Itzik will present a full day seminar on this topic at the SQL DevCon 2004 Conference next February 2004 in London.
And if you are lucky, you could attend his Advanced Transact-SQL course at several locations around the world during the next months.