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: [email protected] 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.
