| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-24 : 07:29:38
|
| Karl writes "We have running 2 SQL servers 2000 in our company.One is running over 3 years, the other over 1 year.They are still on version 8.00.194 (no service pack).Everything is working allright, we only have occasionally some performance problems.My question is, is there a reason to install on both servers service pack 3a ?Can we benefit some performance gains by installing sp3a ?should we follow the rule " it's working, keep your hands off"" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-24 : 07:54:23
|
| I would recommend that you follow the rule "THOU SHALL SERVICE PACK THY SQL SERVER" :-)Seriously, I would strongly suggest SP3a, AFTER testing in your test environment to ensure your applications still work. At the LEAST - go SP2 + the slammer hot fix.Cheers*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-06-24 : 08:18:41
|
| Wanderer is absolutely right. I only comment because I have had to clean up the results of someone saying (its not going to happen to me). Not installing service packs is a open invitation for someone to make a mess of your system or use it for their own purpose. JimUsers <> Logic |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-24 : 10:08:28
|
| Unbelievable. Not having the latest service packs on SQL Server is like sitting dynamite under your servers and hoping it never explodes.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-06-24 : 12:57:25
|
| Holy crap. I better go move the dynamite. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-24 : 13:02:52
|
| When life gives you a database server that does not have service packs installed when they have been available for quite some time, fire the DBA. It is irresponsible of the DBA to not have these installed yet.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-24 : 13:07:49
|
| >> Everything is working allrightThat's a bit of a surprise as some serious bugs have been fixed in service packs.There have been major security vulnerabilities fixed too - I'm guessing you have a closed environment or you would have noticed that.Yes you should apply the service packs otherwise you will have to do it when you come up with a problem to see if it has been fixed. Better to get that possibility out of the way. Remember to test before applying the service packs to a production system as you may be relying on bugs or bugs may be introduced.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-06-24 : 20:49:51
|
| Could always create an instance for testing the service pack out to, but like everyone else is saying here get it pac'd.Keithc MCSE MCSA |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-25 : 03:46:10
|
| wow. Are you at a fortune 500 company? ;)-ec |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-25 : 12:08:25
|
quote:
Originally posted by eyechart
wow. Are you at a fortune 500 company? ;)
I couldn't believe when that dude said that. Why would a fortune 500 company hire someone with so little knowledge? He's got a horribly designed schema and queries and there's pretty much nothing we can do to fix it.Tara |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-28 : 03:58:00
|
| Fortune 500? Huh ... didn't see that anywhere here...*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-28 : 12:29:54
|
| It's from another thread.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-28 : 12:52:01
|
| >> Why would a fortune 500 company hire someone with so little knowledge? He's got a horribly designed schema and queries and there's pretty much nothing we can do to fix it.Happpens all the time.Fortuntely they have lots of money to hire consultants when the realise - either that or decide it's a problem with sql server and migrate to a better database like Oracle or Access.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-28 : 15:07:13
|
quote:
Originally posted by nr
... either that or decide it's a problem with sql server and migrate to a better database like Oracle or Access.
 but maybe that should have been XOR!Kristen |
|
|
|
|
SQL Server 2000 service pack ? yes/no