Views
Top 100 Percent Bug
in earlier versions of SQL server you could add a top 100 percent to the select statement and that allowed you to add an order by clause.
in sql server 2008 the top 100 percent clause is ignored, and the order by clause is ignored.
The workaround is to do something like
select top 100000000 from …