Saving time in writing your code - Intellisense
I have been working on a demo code to simulate a performance based query from a SQL 2005 instance on new 2008 instance for testing purpose. This is to prove how the latest version features can help to attain the performance and to avoid any changes to the code.
Intellisense is most wanted feature by the Developers and even DBAs would agree to include in SQL Server product, by default there is nothing we can expect within SQL 2005 but Microsoft has promised to include the same in SQL 2008. Surprisingly the BOL for July CTP talks about INtellisense with a note that "IntelliSense is not implemented for SQL Editors." The next CTP for SQL 2008 may include Intellisense feature, as I think it is most viewed page in MS Connect site....
Before wrapping this up I would like to suggest SQLPrompt in this regard, which is the best product available in the market and its free to try too.