• Greg Edwards-268690 (4/19/2014)


    Lynn Pettis (4/19/2014)


    SQLRNNR (4/19/2014)


    Lynn Pettis (4/19/2014)


    Greg Edwards-268690 (4/19/2014)


    Lynn Pettis (4/19/2014)


    It is amazing what crap advice people (Gail NOT included) give to others when they ask for help regarding suspect databases.

    I particularly like the fact that the thread was 6 years old.

    And why it went suspect was key to how to plan recovery.

    I wonder if a check engine light comes on, if some of them just pull the motor and get one out of a junk yard as a first attempt to fix? 🙂

    Steve -

    Although attention to details is part of or job, I wonder if something could be done at some time to at least pop up a message that the thread is so old when someone goes to reply.

    Hate to see something that old churning up that kind of advice.

    Especially on top of the correct starting point.

    Hope everyone enjoys the Holiday weekend, if it is one they celebrate.

    Check Engine Light? First stop is AutoZone to have them tell me what the problem is. Costs me nothing at that point.

    Why wouldn't you just go change all your tires and gas tank for that?

    Had a car once that got 50 MPG, at one point the car was down to getting only 40 MPG, solution? Replaced the original spark plugs, wires, rotor and cap and miraculously the car went back to 50 MPG. Of course I did this at 105,521 miles on the car.

    I once bought a 1966 GTO for $800 that had a miss.

    Car only had 15,600 miles on it.

    Spark plug wires, not the valve job the guy was thinking.

    So it pays to diagnose things.

    Wish I still had that one.

    I had a '68 GTO that coincidentally I think I paid $800 for.

    So we have goats and fish in common.


    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St