Paul White NZ (12/16/2010)
Here's just two of the reasons why I've turned it off:
I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):
SELECT rn = ROW_NUMBER() OVER (PARTITION BY N.n ORDER BY N.n)
FROM Performance.dbo.Nums N;
I always write "SELECT *" (horrors!) before going on to type the FROM clause, using a table alias. I then go back and type the column list. Works for me, is the whole of my point.
Sometimes it will work for me; usually it does what I showed. I did have the from clause in there first.
I also frequently have issues when typing FOR XML - as soon as I press space after the XML, it puts in something starting with XML (XMLNameSpaces?)
As Brandie mentioned, it just gets in my way too much, so I turned it off. I like the idea, but not the implementation. Perhaps if there was an option to not do things on keywords, but just objects, it might be okay for me.