Overall I am really happy with Sql Server 2008, especially the intellisense.
However there is one thing that is driving up the wall and that is if you have any columns starting with Id or IDENT_CURRENT to be correct, the intellisense defaults to IDENT_CURRENT so typing a query like
SELECT * FROM [MyTable]
WHERE Id = 1
This becomes especially painful as Id turns to IDENT_CURRENT, so now when I write my query I have to type Id and then point the mouse cursor down to get rid of the Intellisense drop down. This is highly annoying, would appreciate if anyone knows if there's a solution to this.