The SQL Server Premier Field Engineers in Microsoft UK published a nice set scripts on their blogs. Check it out here and here .
Author: Gilles Duchêne The result of a view cannot be sorted. For a lot of developers, this feels like a shortcoming in the SQL language. Instead of applying the correct syntax: Creating & using the view: CREATE VIEW view AS SELECT fields FROM table SELECT fields FROM view ORDER BY fields A lot of people like to write: CREATE...
Summary: There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices...
A great whitepaper on the new stuff in T-SQL written by Itzik Ben-Gan. http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx