SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Service Pack 4


Service Pack 4

Author
Message
GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57899 Visits: 9730
James Stover (12/27/2009)
I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an unspecified number of updates (and years) will it work correctly. The worst part is that we accept and, in fact, expect it. It's irritating that MS isn't giving us SP4 this year. But it's even worse that we should even have to expect one.


So, you don't change the oil in your car? You don't brush your teeth? You don't clean the gutters on your house (or have someone do it for you)?

We live in a universe where the laws of thermodynamics apply. That means complex systems decay and require an input of energy to maintain. That means software will require updates. Until you live in a universe with different laws of physics, that's going to be true.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57899 Visits: 9730
I voted for both of them. Good thought there, Steve. SP3 for 2005 took that kind of nudge to get going, better to act now on this one than wait as long.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146745 Visits: 19434
Thanks for the votes. I've pinged MS, and been patient waiting for the one year anniversary of SP3 to roll by, but no responses. My guess is most of MS is on holiday this week, and that's OK. However we do need the patch to come.

Great analogy on the car. Software does require maintenance and we should expect it. What we should not expect is fundamental errors being left in the product when it's released. I don't think we get that, though SQL SS2K5 had the issue of mirroring not working in RTM and enabled in SP1.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Kit G
Kit G
SSC Eights!
SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)SSC Eights! (814 reputation)

Group: General Forum Members
Points: 814 Visits: 4115
James Stover (12/27/2009)
I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an unspecified number of updates (and years) will it work correctly. The worst part is that we accept and, in fact, expect it. It's irritating that MS isn't giving us SP4 this year. But it's even worse that we should even have to expect one.


Just to throw my 2 cents in, there is no way MS can test all the environments that SQL Server will be put on and to what uses it will be used. As they say, "Nothing is fool proof because fools are so ingenious." As a result, no matter how well they code, someone is going to find some situation that needs a fix.

I play online MMO games. The companies that put them out are always doing patches and improvements. Some of these things shake out during a beta test, most of them don't. One game in particular, years ago, I remember as doing patches of patches of patches before they got it to run properly (and this was after the code apparently went thorugh QA to be released to the client).

The game I currently play patches about every month or so, sometimes more, sometimes less. Not all repercussions of minor code changes are found or caught. I don't mind the patches as each one pretty much improves the overall game. Same thing applies to other software products.

Things change, it's how life is. If the company couldn't change their software to adjust to customer wants and needs, then it wouldn't be worth much in the end, now would it?

-- Kit
Carlos Bossy
Carlos Bossy
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
Points: 97 Visits: 1583
Besides bug fixes, service packs can contain functional and performance improvements, as well as completely new functions. I look forward to them...but I also don't have to apply them. So we have a choice, and I like that.

LinkedIn - http://www.linkedin.com/in/carlosbossy
Blog - http://www.carlosbossy.com
Follow me - @carlosbossy
James Stover
James Stover
Right there with Babe
Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)Right there with Babe (741 reputation)

Group: General Forum Members
Points: 741 Visits: 862
GSquared (12/28/2009)
James Stover (12/27/2009)
I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an unspecified number of updates (and years) will it work correctly. The worst part is that we accept and, in fact, expect it. It's irritating that MS isn't giving us SP4 this year. But it's even worse that we should even have to expect one.


So, you don't change the oil in your car? You don't brush your teeth? You don't clean the gutters on your house (or have someone do it for you)?

We live in a universe where the laws of thermodynamics apply. That means complex systems decay and require an input of energy to maintain. That means software will require updates. Until you live in a universe with different laws of physics, that's going to be true.


I guess what I am wanting to say is that is that the expectation of a service pack is an expectation of a defective product. As a customer, I want to buy a product and have it work. Simple as that. Your examples are maintenance items. If I take your examples and compare to an RTM product, I have oil that damages my engine, a toothbrush that rots my teeth, and gutters that cause rain to pour inside my house. Those things should work - correctly - straight out of the box without the expectation that it will eventually work correctly at some unspecified point in the future after an indefinite number of updates. In this regard, I find service packs unacceptable.


James Stover, McDBA

GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57899 Visits: 9730
James Stover (12/28/2009)
GSquared (12/28/2009)
James Stover (12/27/2009)
I'll go one further - I don't think it's acceptable to have service packs. It's an acknowledgement that a product is defective. Only after an unspecified number of updates (and years) will it work correctly. The worst part is that we accept and, in fact, expect it. It's irritating that MS isn't giving us SP4 this year. But it's even worse that we should even have to expect one.


So, you don't change the oil in your car? You don't brush your teeth? You don't clean the gutters on your house (or have someone do it for you)?

We live in a universe where the laws of thermodynamics apply. That means complex systems decay and require an input of energy to maintain. That means software will require updates. Until you live in a universe with different laws of physics, that's going to be true.


I guess what I am wanting to say is that is that the expectation of a service pack is an expectation of a defective product. As a customer, I want to buy a product and have it work. Simple as that. Your examples are maintenance items. If I take your examples and compare to an RTM product, I have oil that damages my engine, a toothbrush that rots my teeth, and gutters that cause rain to pour inside my house. Those things should work - correctly - straight out of the box without the expectation that it will eventually work correctly at some unspecified point in the future after an indefinite number of updates. In this regard, I find service packs unacceptable.


Yeah. You're right. No car has ever had to be subject to a safety recall. Instead, the manufacturer comes to your house and, for free, fixes the problem for you.

Nothing humans do is without risk. Nothing "works perfectly right out of the box". Expecting perfection is living in a fantasy.

If what you are saying were true, we'd still be driving Model A Fords, because they'd "work - correctly - straight out of the box without the expectation that it will eventually work correctly at some unspecified point in the future after an indefinite number of updates". Your car, whatever car you have, is the end result of a huge number of very expensive updates, and they aren't done yet. It still is killing you and everything around you (toxic exhaust fumes), it still requires the timing belt to be replaced ever X-thousand miles, and the oil to be changed more often than that.

Your doctor, in order to correctly diagnose a wide variety of issues, has to put you at risk of horrible death. He'll subject you to potentially carcinogenic X-rays, CAT scans, etc. He'll cut you open and take pieces of your flesh for biopsies. He'll stick needles in you that could potentially be infected with antiobiotic-resistant, flesh-eating staph. And yet all of this is the end result of tens of thousands of years of constant updates and improvements, and is safer and more effective than any prior version of medicine. But iatrogenic disease (illness caused by medical professionals) still kills more people than computer glitches do. That means the bugs in medicine will continue to be patched, often in a monthly fashion through professional publications.

So, if you brush your teeth (exposing yourself to the potentially toxic/carcinogenic chemicals in your toothpaste and toothbrush - plus the risk of choking on the toothbrush or drowning in the toothpaste foam, which are risks that actually do kill people), if you visit a doctor, if you drive a car or just live in the same atmosphere as people who do, you are taking life-threatening risks that are subject to routine, constant "patches and updates" that improve effectiveness and safety.

I could go on indefinitely. Everything you do carries risks. Every human endeavor is subject to refinement over time and use. What makes you think computer software can be different?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)SSC Guru (215K reputation)

Group: General Forum Members
Points: 215516 Visits: 41979
GSquared (12/29/2009)
Nothing "works perfectly right out of the box".


BWAA-HAA!!! Speak for yourself! ;-)

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57899 Visits: 9730
Jeff Moden (12/29/2009)
GSquared (12/29/2009)
Nothing "works perfectly right out of the box".


BWAA-HAA!!! Speak for yourself! ;-)


I am. Trust me, I wasn't born perfect, I had to work for several weeks to achieve it! :-D

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Clive Chinery
Clive Chinery
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1431 Visits: 154
Steve Jones - Editor (12/27/2009)I'd stick with SPs. One a year seemed like too few, but I'd be happy if we could just get that one.

I also look forward to an annual service pack for current products.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search