differences between versions of SQL serve2005

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?
ThanksI 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/prodin...e-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.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:JAI3j.260$9x7.116@.newsfe05.lga...
>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
>
>|||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
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>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/prodin...e-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.
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:JAI3j.260$9x7.116@.newsfe05.lga...
>|||Hi Larry
1 Proc means 1 Processor.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> 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
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>|||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.
Ekrem nsoy
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> 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
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>|||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,
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:52F09469-E27E-419E-960F-44BEAC5C0AEE@.microsoft.com...
> 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.
> --
> Ekrem nsoy
>
> "Larry Killen" <lkillen@.charter.net> wrote in message
> news:5FK3j.127$Wl1.49@.newsfe06.lga...
>|||Larry,
As Kalen pointed out I meant Processor. But I highly recommend you review
the document I listed for all the differences.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Larry Killen" <lkillen@.charter.net> wrote in message
news:5FK3j.127$Wl1.49@.newsfe06.lga...
> 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
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uEu5$8uMIHA.5224@.TK2MSFTNGP02.phx.gbl...
>