MB Software Solutions <> wrote: > Rick Schummer wrote: >> I don't think he was referring to SQL Server 2005. I believe he is >> referring to Management Studio for SQL Server *Express* is dog slow, >> even on latest and greatest hardware. It is a pig and should be >> considered an embarrassment to the SQL Server team. >> > Since the Express is the "free" version (correct me if I'm mistaken), > perhaps they've intentionally made it slow so as to make the non-free > version more appealing? Just a WAG...
In MSDE there was a governor. In 2005 Express it's been removed. The difference is that Express WON'T use multiple processors if present, and has an upper limit of ram, I think I remember 2 gig but who knows if that was just during the beta phase. So in Express they doubled the usable disk space, took away the concurrent user limit, and added much better security if your using AD. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr. http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.16.7/620 - Release Date: 1/8/2007 4:12 PM _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
