jwcolby
jwcolby at colbyconsulting.com
Fri Sep 10 16:19:01 CDT 2010
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx John W. Colby www.ColbyConsulting.com On 9/10/2010 5:03 PM, Jim Dettman wrote: > > This one says 4: > > http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx > > and I've always known it to be 4. Could have changed it though for > 2008.... > > Jim. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby > Sent: Friday, September 10, 2010 4:07 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] SQL Server Express - true skinny > > I took the 10g right from their web page "comparing versions". > > John W. Colby > www.ColbyConsulting.com > > On 9/10/2010 3:35 PM, Jim Dettman wrote: >> >> <<So the question is, would SQL Server express be capable of replacing Jet >> for a complex bound >> application for 30 users?>> >> >> I've never had occasion to try it myself, but from what I understand, > for >> 2005 and up that is correct. The old 5 connection limit was removed. >> >> However the DB limit is 4GB, not 10. >> >> Jim. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Friday, September 10, 2010 2:09 PM >> To: Access Developers discussion and problem solving; Sqlserver-Dba; VBA >> Subject: [AccessD] SQL Server Express - true skinny >> >> Does anyone know the true skinny on the limitations placed on SQL Server >> express in order to >> "throttle" it.? >> >> I found a blog that claims that outside of CPU / Memory / DB size >> limitations, there is not other >> "governor". >> >> So it appears that the limitations are: >> >> 10 gig db file size. This does not discuss additional database files. >> 1 CPU. However it appears that it can use 4 cores if available >> 1 gig of memory. This appears to be the killer. >> >> But there appears to be no "user" limitations etc. >> >> So the question is, would SQL Server express be capable of replacing Jet > for >> a complex bound >> application for 30 users? >> >>