• If it weren't so true, it actually would be funny. "Upgrade Tuesdays" seems to occur on the 1st Tuesday of each month. That Thursday after, the folks in NetOps are required to do OS/Windows Upgrades to all the Dev boxes, the Staging boxes the Thursday after that, and then the Prod boxes the week after that but on the bloody weekend. I'm lucky that I don't have to be around for any of that but I sure do feel sorry for the folks in NetOps. It's a company policy that I dug in on and said NFW to (and have been able to enforce it) when it comes to CUs and SPs on SQL Server. I'll evaluate the CUs if there's something critical that we need and normally limit it to just a hotfix if one is available. Even then, they don't hit production until they've run the gauntlet of testing in the Dev and Staging environments.

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

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)