|
|
Posted by Greg D. Moore \(Strider\) on 10/24/07 11:33
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99D2F206743A5Yazorman@127.0.0.1...
> Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes:
>> No, and there never has been. That's a misunderstanding of the old
>> query governer built into MSDE (whcih permitted only 5 or 6 (I've seen
>> both numbers)) of queries to run at the same time before things were
>> slowed down on purpose).
>>
>> SQL Server Express 2005 does not have that limit. Rather it is limited
>> in
>> DB size (2GB), CPU (1) and memory (I believe 1GB). But within those
>> parameters it operates at full-speed and works very well.
>
> But keep in mind that SQL Express does not come with SQL Agent, which can
> be a killer for Neil if he wants to schedule backsup and that.
Good point.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Navigation:
[Reply to this message]
|