Forum Replies Created

Viewing 15 posts - 16,486 through 16,500 (of 22,213 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/18/2009)


    Grant Fritchey (9/18/2009)


    Lynn Pettis (9/17/2009)


    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep...

  • RE: Can't explain lengthy runtime for a query. . .

    Oh, and, in cases like this, all the execution plans are going to be relevant.

  • RE: Can't explain lengthy runtime for a query. . .

    Table variables don't have statistics. That's probably the issue based on how you're using them in JOIN's. Try doing the same thing with temporary (#temp) tables and see if it...

  • RE: Qry Performance

    You may have an index, but is it getting used? Have you looked at the actual execution plan? Can you post it?

  • RE: Are the posted questions getting worse?

    GSquared (9/18/2009)


    Paul White (9/18/2009)


    Whenever I consider writing for SSC, two things put me off:

    1. The submission process itself; and

    2. The daft comments

    Paul

    I must be doing something wrong. ...

  • RE: Performance Question with SELECT

    Assuming you're talking about a situation where you're running SELECT... SELECT... SELECT... SELECT... and you're not putting all kinds of IF logic in there, then yes, running all four at...

  • RE: Execute StoreProcedure paramters

    Yep, sorry, parsed this sentence multiple times and I'm still confused.

    Could you explain in a bit more detail what it is that you're trying to do?

  • RE: Back up between specific duration

    Jim-1146873 (9/17/2009)


    Hi,

    Can anyone help me out how to take a backup of a database between a specified duration.

    For ex, i want to take back up between August 1st 2009 and...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/17/2009)


    Just an FYI for the denizens of The Thread, next Tuesday I have another article being republished here on ssc as well. Keep an eye out as...

  • RE: How To Efficiently Index Using a VARCHAR Column?

    Jeff Moden (9/17/2009)


    To the rest of you folks, I just want to say "Thanks" for backing me up. I've been under the weather and in bed for the last...

  • RE: Are the posted questions getting worse?

    Bob Hovious-584421 (9/17/2009)


    Chicks dig scars.

    Did anyone ever say where Gail disappeared to?

    She hasn't been here recently, but she's still about. She posted a comment over on my blog recently (fixing...

  • RE: Are the posted questions getting worse?

    lmu92 (9/17/2009)


    Grant Fritchey (9/17/2009)


    Actually, I think that one was just a misunderstanding. He didn't get that Jeff was showing him how to set up a test for his index... I...

  • RE: Why do we need to reboot the SQL server..?

    Seth Lynch (9/17/2009)


    sanjeev_krs2004 (9/17/2009)


    Hi -

    Its just a simple maintenance plan where I am rebuilding indexes, reorganizing indexes, shrink database...etc. All the usual stuff. Secondly, I am not sure but...

  • RE: Are the posted questions getting worse?

    lmu92 (9/17/2009)


    Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work...

  • RE: Resoring SQL SERVER without Backup

    Silverfox (9/17/2009)


    Grant Fritchey (9/17/2009)


    From what I can see, it looks like REPAIR_DATA_LOSS has fixed the issue (at what cost, you have yet to find out). What problem are you having...

Viewing 15 posts - 16,486 through 16,500 (of 22,213 total)