[AccessD] SQL Server Express - true skinny

jwcolby jwcolby at colbyconsulting.com
Fri Sep 10 16:29:06 CDT 2010


That whole thing is an interesting read.

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



More information about the AccessD mailing list