When running SQL Server Management Studio 2008 on a Win7 64bit machine you might stumble upon poor, very poor performance. Clicking on a table results in waiting for 10-20 seconds before being able to do anything, doing a select would again take an eternity. The reason is unknown to me (sorry, I don’t feel like reading tons of articles and kb notes).
Still I got it fixed. Just two steps:
- set the management studio to run in XP SP3 compatibility mode
- if you have the UAC turned off, turn it on on the first level (raise the level from the bottom one notch)
Now it’s working like a charm.