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.
Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen the Cook Sent: Monday, January 08, 2007 09:52 PM To: [EMAIL PROTECTED] Subject: RE: [NF] SQL Server Management Studio Express Stephen the Cook <> wrote: > Man-wai CHANG <> wrote: >> It's really a pig in both speed an size... is there trick to speed it >> up? >> >> (what the hell is it+.Net doing in the background??) > > What is slow? I have found that heavy batch operations that would generate 40,000 transactions a run would run faster in 2005 then 2000. That would be a batch process that took 3 hours to run went down to 2.25 running the same .net code base just a different sever instance for 2005 instead of 2000. (Same machine) Granularity became much better so your security is much tighter. Encryption of a column is real cool also. So what wasn't running fast anyway? 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/619 - Release Date: 1/7/2007 6:29 PM [excessive quoting removed by server] _______________________________________________ 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.