Visual C++ in Visual Studio 10 will use SQL Server Compact instead of ncb's
For many this will no doubt induce a sigh of relief, we've all been there in moderately sized projects and then happened to see that the ncb file size seems to have grown exponentially - I don't think I've ever met someone who hasn't deleted the ncb file numerous times to try and coerce the IDE to give some intellisense support.
I'm sure they will have to jump through some hoops, but it makes perfect sense to go with something that the database guys have put an immense amount of work in, as a result I'm sure we will see vastly reduced file sizes and superior response times in terms of intellisense, hopefully the implementation will be "good" enough to implement other features like refactoring support, probably not as comprehensive as C# or other managed languages but anything is an improvement.
This is great news though, Jim Springfield the VC++ architect has more on this here, if you want to skip to the more interesting stuff then read the last paragraph which talks about scaling the source code information (SQL Server instance) and some potential features.
Interesting stuff.