Which version of SQL Server 2008 to use

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Which version of SQL Server 2008 to use

Author

Topic

DaScribe
Starting Member

3 Posts

Posted - 2012-08-07 : 11:59:06

Hi All

Not sure if this is a stupid question, but I'm quite new to SQL Server.

My company is setting up an e-commerce site and the developer wants to use SQL Server 2008 r2. I've only used MySql before. No doubt I'll be back here for more info later!

What I need to know is which version of SQL Server 2008 to buy and install on our server.

We will be using a databse with 10's of thousands of product records, and really only using it as storage accessed by IIS from various web sites as well as the e-commerce site. The number of versions is a bit bewildering. The Small Business WorkGroup looked fine on the pricing.

Any information would be of great use

Thanks in advance

I'm waiting for my real life to begin

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-08-07 : 12:25:53

Who's going to support it? The developer? If so then it would make sense to go with their experience.

If not then for your workload pretty much anything will probably work so I think the maintenance will be the driving factor.

I'd say SQL Server does a pretty good job maintenance wise out of the box (compared to Oracle say) but still, if you have no experience with it that may be something to think about,

Transact Charlie

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

http://nosqlsolution.blogspot.co.uk/

DaScribe
Starting Member

3 Posts

Posted - 2012-08-07 : 13:57:16

Hi Transact Charlie

I'll be supporting it! As I said I'll be back here for more info.

We will also port our MySql databses over to SQL Server once this e-commerce site is up and running, so getting it right now is a must.

We have a bought in product database that has scripts for importing and updating SQL Server, so it looks like goodbye to Oracle MySql.

Still need to make the decision on what version.

--------------------------------------
I'm waiting for my real life to begin

--------------------------------------

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-08-08 : 04:10:10

I think Small business has a maximum connection limit of 75?

If your web layer is using a connection pool more than this then it may be a very bad choice.

I've only ever worked with Standard and Enterprise so I'll bow out here and let others with more experience advise you.

Good luck! This is a great site to post on for help so someone will comment soon.

Transact Charlie

Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

http://nosqlsolution.blogspot.co.uk/

DaScribe
Starting Member

3 Posts

Posted - 2012-08-08 : 05:22:49

Hi Transact Charlie

Thanks for the info !!!

"Connection limits" is nothing I thought of !!! Thats what I call useful.

I'll talk to the e-commerce developer about that.

Thanks again

--------------------------------------
I'm waiting for my real life to begin

--------------------------------------

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources