SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Andy Leonard

Add to Technorati Favorites Add to Google
 

Open SQL Server Management Studio (SMSS) quicker

By Andy Leonard in Andy Leonard | 03-24-2006 11:05 AM | Categories:
Rating: (not yet rated) |  Discuss | 901 Reads | 72 Reads in Last 30 Days |1 comment(s)

Almost every weekday morning I read Steve Jones' thoughts published in the SQLServerCentral newsletter editorial section. Today (24 Mar 2006) he mentioned SQL Server Management Studio loads and opens slowly. I agree with Steve - I hate waiting for software to load.

As a developer, I know it's a trade-off between "at my fingertips" functionality and having to wait for everything to load as I click on it, and I think making me wait once at the beginning is the right choice - but it doesn't help... I still hate waiting.

I found a couple of changes that helped me. I'm sure there are more and I encourage you to add your tips and tricks as comments.

First, I open the Registered Servers view (View, Registered Servers):

Next, I register some servers (right-click Database Engine in Registered Servers view, click New, then click Server Registration):

Next, open SSMS Options (Tools, Options):

Finally, I set the environment to "Open empty environment":

Click OK to accept the changes.

This shaves some time off opening the SSMS environment. Again, please add your tips and tricks!

:{> Andy

Comments
 

Andy Leonard said:

I saw this in a response to to Steve's editorial and I learned by dumb luck one day (I accidentally logged into a SQL Server 2005 instance using QA).

Remember: you can use SQL Server 2000 Query Analyzer with SQL Server 2005.

:{> Andy
March 24, 2006 1:07 PM
Leave a Comment
Only members of SQLServerCentral may leave comments. Register now for your free account or Sign-In if you are already a member.