Re: [NF] SQL Server Management Studio Express
I run it in an XP virtual machine and it is a mite tardy for sure. -- Alan Bourke [EMAIL PROTECTED] -- http://www.fastmail.fm - Email service worth paying for. Try it for free ___ 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.
Re: [NF] SQL Server Management Studio Express
Paul Hill wrote: A few years ago I was migrating a bunch of Fox data to MSSQL. I was using a spare PC running MSDE (the previous incarnation of SQL Express) to develop the conversion routines but my data hit the 2 Gb limit. So I installed Win2K Server full SQL 2000 on the same box. The same data scripts run a hell of a lot faster, *and the resulting data was less than 2GB*. Funny that. *and the resulting data was less than 2GB* Why do you suppose that I wonder? Stored as perhaps differing field types (char vs varchar)? I eluded to the governor switch idea that was in place in MSDE whereby it would purposely slow down after so many concurrent queries. I thought perhaps they had other governor switches in place to limit the freebie version too. ?? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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.
RE: [NF] SQL Server Management Studio Express
Rick Schummer wrote: Ok, what is slow? The time to start it up, or the time to change db's or servers and have all those objects in the IDE? Yes. Yes. Yes. Yes. (attempting my best to not sound sarcastic, but it is all slow) I want to reiterate, I am referring to the SQL Express version, not the regular version. I have no idea if they are the same or different code bases and have not used the one that comes with the standard, developer, or enterprise edition of SQL Server 2005. My experience is on one machine that is a couple of years old with *only* 512MB RAM. I have seen it demoed by presenters and it appeared slow on their machines as well. Hopefully it is addressed in the service packs. Ok. I'll say the RAM volume is your problem that can be overcome. I don't have SQL Express installed, just SQL 2005 Developer. I'm waiting on getting the Data Buddy or the team Foundation version of SS2005 for this new project I'm on. 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.
RE: [NF] SQL Server Management Studio Express
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.
[NF] SQL Server Management Studio Express
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??) -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.1 ^ ^ 20:28:01 up 27 days 2:40 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk ___ 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.
Re: [NF] SQL Server Management Studio Express
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??) But then everything manufactured and patented by Micro$oft is not edible well I guess... .hmm -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.19.1 ^ ^ 21:34:01 up 27 days 3:46 0 users load average: 1.00 1.02 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk ___ 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.
RE: [NF] SQL Server Management Studio Express
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? 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 ___ 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.
RE: [NF] SQL Server Management Studio Express
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.
RE: [NF] SQL Server Management Studio Express
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. Ok, what is slow? The time to start it up, or the time to change db's or servers and have all those objects in the IDE? Lately I work with SQL2000 all the time. 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 ___ 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.
Re: [NF] SQL Server Management Studio Express
Stephen the Cook 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. Ok, what is slow? The time to start it up, or the time to change db's or servers and have all those objects in the IDE? Lately I work with SQL2000 all the time. Lately I work with PostgreSQL all the time - and it is NEVER slow :) 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/ ___ 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.
RE: [NF] SQL Server Management Studio Express
Ok, what is slow? The time to start it up, or the time to change db's or servers and have all those objects in the IDE? Yes. Yes. Yes. Yes. (attempting my best to not sound sarcastic, but it is all slow) I want to reiterate, I am referring to the SQL Express version, not the regular version. I have no idea if they are the same or different code bases and have not used the one that comes with the standard, developer, or enterprise edition of SQL Server 2005. My experience is on one machine that is a couple of years old with *only* 512MB RAM. I have seen it demoed by presenters and it appeared slow on their machines as well. Hopefully it is addressed in the service packs. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax ___ 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.