A long, long time ago, ORDER BY in a view meant something. People still think so. Read why…
February 2012
Tip : Checking for potential constraint violations before entering SQL Server TRY and CATCH logic
By way of an example, see why most of what you hear about SQL Server is only true some of the time, at best.
Tip : Troubleshooting IntelliSense in SQL Server Management Studio