differences between versions of SQL serve2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Killen - 30 Nov 2007 00:15 GMT

I just purchased 2 copies of SQL Server 2005 standard edition at the tune of
$1000 each. It comes with 5 CALs. I had been using SQLExpress 2005 but
decided to use the full version prior to shipping the deliverable. When I
went to install the software (on a michine with SQL Express already
installed) I was essentially told that everything that I wanted to install
was already there!

So what did I gain for my $1000??

Actually I believe I am going backwards. I do not know the limits for
concurrent connections for SQLExpress but I had vereral clients connected
and it never complained. Byt I am now limited to 5 seats!

This is a reasonably low duty server running on WinNT with a simple dual
core processor. It is not critical. I was able to stress the SQL Express
server by sending it data at a 30X rate of normal operation without any
problems.

The server goes out with a $275K piece of equipment so I did not mind the
expenditure but if I gain nothing...well it is hard to justify.

Or am I missing something?

Thanks

Reply to this Message

Andrew J. Kelly - 30 Nov 2007 01:20 GMT

I don't know what the actual message stated but Express and Std are not the
same things. Yes they share the same code base etc but Std comes with SSMS
and Express does not. Actually you can download SSMS express. But Std gives
you unlimited memory usage, up to 4 procs (not counting cores) and unlimited
db size plus a lot more. Express is limited to 1GB memory, 4GB db and 1 Proc
plus some others like does not include SQL Agent etc. See more here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

As long as you don't need any of those missing features or won't exceed the
limits of Express it would have been just fine. By the way Workgroup may
also have been an option and it's half the cost of Std.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

>I just purchased 2 copies of SQL Server 2005 standard edition at the tune
>of
[quoted text clipped - 21 lines]
>
> Thanks

Reply to this Message

Larry Killen - 30 Nov 2007 02:36 GMT

Thanks Andrew,
I was aware of the memory llimitation though I did not know about the memory
limit. Considering that we replaced Paradox with MSDE and now Express, I
think Express will suffice.

I am unsure what you mean by "1 Proc ". Do you mean Stored Procedure? I
have several running under both MSDE and SQLExpress.

Thanks
Larry

>I don't know what the actual message stated but Express and Std are not the
>same things. Yes they share the same code base etc but Std comes with SSMS
[quoted text clipped - 37 lines]
>>
>> Thanks

Reply to this Message

Kalen Delaney - 30 Nov 2007 03:47 GMT

Hi Larry

1 Proc means 1 Processor.

Signature

HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
[quoted text clipped - 50 lines]
>>>
>>> Thanks

Reply to this Message

Ekrem Önsoy - 30 Nov 2007 08:42 GMT

The thing that surprized me that you did not even bother yourself to take a
look at the differences between editions of SQL Server before buying its
licenses and now your are complaining. This is weird indeed.

Signature

Ekrem Önsoy

> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
[quoted text clipped - 50 lines]
>>>
>>> Thanks

Reply to this Message

Larry Killen - 30 Nov 2007 12:07 GMT

I am the developer. Others make the purchasing decision. We are a
manufacturing company and do a lot of things the "wierd" way. Thank you,

> The thing that surprized me that you did not even bother yourself to take
> a look at the differences between editions of SQL Server before buying its
[quoted text clipped - 56 lines]
>>>>
>>>> Thanks

Reply to this Message

Andrew J. Kelly - 30 Nov 2007 14:50 GMT

Larry,

As Kalen pointed out I meant Processor. But I highly recommend you review
the document I listed for all the differences.

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

> Thanks Andrew,
> I was aware of the memory llimitation though I did not know about the
[quoted text clipped - 50 lines]
>>>
>>> Thanks

Reply to this Message