[AccessD] SQL Server Express - true skinny

jwcolby jwcolby at colbyconsulting.com
Fri Sep 10 15:07:18 CDT 2010


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?
>
>



More information about the AccessD mailing list