I've just started to trial SQL2008 CTP6 (version 10.0.1300.13).
One of the features I was looking forward to was Intellisense, but it hasn't matched my expectations.
It wasn't so much the list of objects, or functions that I wanted to use Intellisense for, but more for things like the list of parameters for a function. For example, I can never remember the correct order of the parameters for SUBSTRING, or for REPLACE, and I was hoping that intellisense would at least give me a helpful hint, but it just lists, for example, "Param1 varchar, Param3 varchar, Param5 varchar" for REPLACE.
I *know* there are 3 parameters needed, one for the string to search in, one for the string to find, and one for the string to replace with BUT it's the order I forget!!!