[AccessD] SQL Server Express - true skinny

Doug Murphy dw-murphy at cox.net
Fri Sep 10 16:24:14 CDT 2010


SQL Server 2008 Express home page would seem to imply 4G, but
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx says
10G/1 CPU. Nothing about connections as with 2003 version. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, September 10, 2010 2:04 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Server Express - true skinny


 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?
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list