Tuesday, January 02, 2007
Good Riddance, Query Analyzer!

I just recently started using Microsoft SQL Server Management Studio Express (SSMSE).  This free tool is intended for SQL Server 2005 databases, but it works just fine with MSDE and SQL 2000 databases, as far as I can tell.  SSMSE obsoletes the tools I have been using up to this point, namely Enterprise Manager and Query Analyzer.

Enterprise Manager is slow to open on most systems I've used.  I have a server instance with 20 databases and I can take a nap before the thing finishes opening up.  SSMSE uses demand loading of the tree nodes, so performance is a lot better.

The whole integration between Enterprise Manager and Query Analyzer has a more natural feel.  Nice job, MS!

posted on Tuesday, January 02, 2007 4:25:55 PM (Central Standard Time, UTC-06:00) by Christopher S. Velazquez
digg it!     del.icio.us     Live it!     Newsvine     Facebook #    Comments [4] Trackback
Related posts:
Microsoft publishes PostgreSQL how-to
Why Office 2007 Really Does Rock
SubSonic - The Zero Code DAL
Bad Indexing Can Degrade Database Performance
 Tracked by:
http://negator.startlogic.com/sitemap1.html [Pingback]
http://guga.readyhosting.com/sitemap1.html [Pingback]
http://hv5tlsh.net/sitemap1.html [Pingback]
http://uo5jjuh.info/03/sitemap1.html [Pingback]
http://freewebs.com/ursaler/free/sitemap1.html [Pingback]
http://tdafxb2.net/sitemap1.html [Pingback]
http://freewebs.com/sinkopa/00/sitemap5.html [Pingback]
http://sinkopa.webs.com/02/sitemap3.html [Pingback]
http://host264.hostmonster.com/~battery1/sitemap1.html [Pingback]
http://certint.homestead.com/09/gilbert-godfrey.html [Pingback]
http://kopluter.homestead.com/07/paparazzi-oops.html [Pingback]
http://dujpoet.homestead.com/02/coupons-inc.html [Pingback]
http://sutropa.homestead.com/09/spinning-wheel.html [Pingback]
Tuesday, January 02, 2007 5:03:39 PM (Central Standard Time, UTC-06:00)
One bogus thing I found is that SSMSE asks everytime you close a query window. In Query Analyzer I was able to suppress this behavior, but in SSMSE you can't, or I just haven't found out how yet.
Chris
Friday, January 19, 2007 2:55:21 AM (Central Standard Time, UTC-06:00)
Thank you for the link bro. I'm using it now.
Have you noticed that when you backup a 2000 DB though it doubles the size? Is this because it converts it to 2005?

Just curious. Great info though.
Jason Meridth
Friday, January 19, 2007 12:02:39 PM (Central Standard Time, UTC-06:00)
Interesting. I'll have to look at that. Maybe that's why MS gives you 4 GB with SQL Express instead of 2 GB like MSDE. Doh!
Chris
Tuesday, June 02, 2009 3:19:05 AM (Central Standard Time, UTC-06:00)
Good afternoon. The great thing about a computer notebook is that no matter how much you stuff into it, it doesn't get bigger or heavier.
I am from Czech and learning to write in English, give please true I wrote the following sentence: "Search drug information, interaction, images medical diagnosis."

With love :D, Sanders.
Sanders
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):
Page rendered at Friday, July 30, 2010 6:16:10 AM (Central Standard Time, UTC-06:00)