Sql Server 2008 is going to rock

Here are the top 10 reasons why.

1. In line variable assignment

     Instead of:

            DECLARE @myVar int 
            SET @myVar = 5

   you can do it in one line:

           DECLARE @myVar int = 5

2. Intellisense 

In the SQL Server Management Studio (SSMS).  This has been previously possible in SQL Server 2000 and 2005 with  use of 3rd party add-ins like SQL Prompt ($195).  But  these tools are a horrible hack at best (e.g. they hook into the editor window and try to   interpret what the application is doing). 

3. Math syntax like C  

      SET @i += 5.  Enough said.  They finally let a C# developer on the SQL team.