Menu
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.
865
It is because when SSMS loads, it Starts the Object Explorer which has our Database and Server information. Loading these information takes more time resulting delaying in start of the application. One thing you can do is, go to Tools > Options > Environment > Startup > Select Open Empty Environment.
SSMS takes 10-20 + minutes to open.
5) Which technique is used to increase the size of database? Replication is used to increase the size of database.
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.
165
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
