For the first time I tried to write a stored procedure in SQL Server 2008 query editor in SQL Management studio. I was impressed to see how complete intellisense support has been implemented in SQL Management studio. It event recoganized alias table name. And when i entered DOT after alias name, it immediately gave me name of all the columns in the table. Made my life very easy. In the past I had to keep tree view open for a given table in left side to see all the column names. Good work Microsoft team!