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


Hot Fixes and QFEs


Hot Fixes and QFEs

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)

Group: Administrators
Points: 690307 Visits: 21596
Hot Melt Glue
Where you aware of this? Hot Fixes are cumulative, meaning that each released hot fix includes those released prior to it.


It makes perfect sense to me. You don't want 6 different code bases to maintain, each with different hot fixes installed and then try to merge them once a year for a service pack. I couldn't imagine the various permutations, especially if you dig through the list of hot fixes for SQL Server 2005. By the last list I've seen, there have been 29 different builds release, possibly more.


However this is important for those of you that are thinking of applying a hot fix to your server. In fact, it's rather important that you are aware of what to test. If you apply HotFix 7 to fix some issue and Hot Fix 4 changed some behavior that exists in your application, then you should be regression testing the behavior for Hot Fix 4.


Which means that Microsoft needs to do a better job of linking all Hotfixes to all previous hot fix changes that are included. When I look at the latest Hotfix rollup for SP2 (build 9.0.3152), I should see a list of changes.


And I do. All the changes are linked to their Bug number and a description. I'd like to see these linked to other KB articles and those hotfixes as well, but this is a start. If I look at a pre-SP2 hotfix, like FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load, I don't see previous HotFixes linked or included. Which means that if I were possibly affected by a previous fix, I might be confused.


We all need to be sure we document carefully which patches and fixes we apply to servers, but Microsoft needs to be sure they give us the information about what is changing as well. I don't expect separate fixes that aren't included in the core code branch, but I do want to know what I'm applying to my server.

CraigIW
CraigIW
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2123 Visits: 235

Are you really sure about this? And is it only for SQL Server? Every hot fix I have ever installed for another product explicitly states 'this hotfix is deisgned to resolve the particular issue described here, only apply it if you are experiencing these symptoms'. A hotfix rollup, well that's fair enough, the name itself says 'this is all the hotfixes since the last service pack' but that's exactly what you would expect, it's a rollup. I have never seen an individual hotfix that includes previous hotfixes.

Craig


Summer90
Summer90
SSC-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31762 Visits: 4331
Is it me or does it appear that Microsoft is a little sloppy in SQL 2005? I have been disappointed in finding so many simple problems with the RTM, SP1, SP2 etc....
Steve Jones
Steve Jones
SSC Guru
SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)SSC Guru (690K reputation)

Group: Administrators
Points: 690307 Visits: 21596
Microsoft has been a little sloppy with SP2. I wonder if they put too much of a testing burden on Beta and CTP testing and getting feedback.

I got this from an MVP, who heard it at the MVP Summit two weeks ago. I've never seen hotfixes mentioned that they include previous ones, but from a coding perspective, it makes sense. If you had 4 hot fixes you were working on, would you have 4 branches of SP1 code? Or 5 including the SP2 branch? Would you then try to merge them together?

No, you'd build on the previous hot fix code.

I think this is a huge failing on Microsoft's part in not making this very clear to people in all their products and linking to the previous service pack and hot fixes that are included.

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
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