Microsoft SQL Servers

[ttadast]

I have just one simple question that gives me headache every time I think about it. What Microsoft SQL version you suggest to use? Why most of all uses 2000? He is old. Why not to use 2005 or 2008 or 2008 R2 or even 2012? Someone please answer this question with arguments.

 

[arvis1192]

Well 2000 is old and kinda crappy. But lot of people don't like newr versions. No idea why.. Guess most of 2000 users still use XP as well.

 

[KarLi]

2k is easiest and best use . If u want smthin different then use 2.5k or wtv.

 

[ttadast]

OK thank you, but about performance. For faster databases connection betwean server and people I should choose older 2k version or newer 2k5 version? This is most important interest.

 

[Ooo Yee]

it depend of server files, some teams need 2k some 2k5 some 2k8, the same as os.

 

[Ema Leto]

2k5/8, bcoz its more easy to make tables, procedures, querrys, more fast.

 

[1Word]

I think all of them are almost as fast, also remember when webzen made MuOnline there was only MSSQL 2000.

Just use the ones recommanded for the server files, all work fine, also I find 2000 a bit easier to use, dunno why

 

[Ytys Vynsan]

Doesn't matter which you use, just make sure you have load balanced internet connections,

for example a 4 port load balancer, which i always find does the trick for both mu servers and hosting websites etc

But Linux all the way as far as performance goes.. with sql at least

Regards,
Ytys Vynsan

 

[ttadast]

Thank you all.

 

[ImReem]

i used 2008.

 

[Nocturnal]

im looking forward into using 2k8 aswell.. any1 here encounter problems or difficulty with it ?

 

[1Word]

I had 2k8 no problems, and all versions work the same (must only be compatible with the dataservers)

Client send <character name> - Server > Database
Database > Server - Client Receive <character name>

Also people will start using 2012 soon ^^

 

[anhdenday]

2k8 and that is good version to you

 

[pizdets2]

2008 r2 is the best i used so far better run it on server 2008 all will be flawless