I was super excited about it, and while it may just be that I'm so used to coding without it that I can't appreciate it yet, so far it just seems like an annoyance. Half the time I've fully typed out the field name and hit return... except that only selected the field name I'd already typed instead of moving to the next line. Short field names like 'ID' are exceptionally annoying. The word-like syntax error red underlines are pretty cool tho.
Hmm. I like the idea. But i'm getting red underlines on code which works. "Invalid object name" - only it's perfectly valid SQL which executes.
select * from dbo.Format f
has 'dbo.Format' underlined, but it exists in MyDB.
I'd use redgate sql prompt/refactor only I can't justify the cost at home (use it at work though -it's great).
Edit: Ah - about 2 minutes after posting this, while I was playing around with the query, the 'error' underlining went away. This is on a quad core PC which was doing absolutely nothing else, with a stock install of sql server 2008. Contrast this with RedGate's third party plug-in, which reflects changes immediately. Well on form for Microsoft!