Is it just me, or does expanding the list of databases in SQL Server 2008 Management Studio take significantly more time than expanding the list of databases in SQL Server 2005 Management Studio?
If it isn't just me, is there an explanation for this behavior? Whatever it is doing in the background that makes it take longer, can we turn that off? Is it configurable?
I know, it seems trivial, but I am perpetually being surprised at how long this takes.
Most of the systems I have worked on have 200 or fewer tables. That should be near instantaneous.
The only times I've ever seen a slow down is in systems under heavy load or if my network connection to the database server is slow. In which case it is completely dependent on factors outside my control.
In SQL Management Studio 2008, select the "Databases" node in the Object Explorer. Then, click View --> Object Explorer Details. Right click on one of the column headers and uncheck all of the columns besides "Name". These columns are slowing down the process of expanding the database list.