Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 9,399 total)

  • RE: Archiving Data Script

    It sounds like this is a maintenance process that should be run off-hours.

    You have calls in your table from the year 1899? :ermm:

    Did you try to update the code to...

  • RE: Today's Random Word!

    djj (8/11/2015)


    Eirikur Eiriksson (8/11/2015)


    Ed Wagner (8/11/2015)


    TomThomson (8/10/2015)


    SQLRNNR (8/10/2015)


    centrifuge

    acceleration

    Velocity

    Inertia

    Energy

    Force

  • RE: Print a nvarchar variable

    Good question, different than normal, made me read the answers carefully and illustrates a good point. Thanks.

  • RE: SQl DBmail problem

    Did you configure the authentication in the settings for the account?

  • RE: Detecting Differences in Files on Servers

    DennisPost (8/11/2015)


    Great article! Really well written!!

    Thanks, Dennis. I appreciate the feedback.

  • RE: Today's Random Word!

    TomThomson (8/10/2015)


    SQLRNNR (8/10/2015)


    centrifuge

    acceleration

    Velocity

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/10/2015)


    Jack Corbett (8/10/2015)


    Steve Jones - SSC Editor (8/10/2015)


    Query query, sql sql, should we debate tomatoes and potatoes as well?

    How about "daytah" vs. "dahtah"?

    OMG. That was on...

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/10/2015)


    SQLRNNR (8/10/2015)


    Brandie Tarvin (8/10/2015)


    SQLRNNR (8/10/2015)


    Alvin Ramard (8/10/2015)


    Ed Wagner (8/10/2015)


    Lynn Pettis (8/10/2015)


    SQLRNNR (8/10/2015)


    48 bottles of post on the thread, 48 bottles of post.

    Take one down, pass it around, 48...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/10/2015)


    SQLRNNR (8/10/2015)


    48 bottles of post on the thread, 48 bottles of post.

    Take one down, pass it around, 48 bottles of post on the thread

    ?? Start with 48, take...

  • RE: Archiving Data Script

    Welsh Corgi (8/10/2015)


    Yes I should go with Try, Catch but I was to loop so that I only commit so many records at a time.

    What about the part about ditching...

  • RE: SQl DBmail problem

    vs.satheesh (8/10/2015)


    "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2015-08-10T21:53:54). Exception Message: Cannot send mails to mail server....

  • RE: Archiving Data Script

    Did you read this post from Gail?

    GilaMonster (8/10/2015)


    If you want to be able to rollback, then ditch the entire loop construct and just have the insert and the delete as...

  • RE: Fragmented Indexes

    delizat (8/10/2015)


    Lynn Pettis (8/7/2015)


    delizat (8/7/2015)


    Every situation is different, but this is the order of my backup jobs:

    1. Reorganize/Rebuild index

    2. Check integrity

    3. Update Statistics

    4. Backup database.

    Please tell me you aren't updating...

  • RE: Today's Random Word!

    Luis Cazares (8/10/2015)


    crookj (8/10/2015)


    Ed Wagner (8/10/2015)


    djj (8/10/2015)


    Ed Wagner (8/10/2015)


    BL0B_EATER (8/10/2015)


    Stuart Davies (8/10/2015)


    TomThomson (8/9/2015)


    SQLRNNR (8/8/2015)


    Ed Wagner (8/8/2015)


    Eirikur Eiriksson (8/8/2015)


    SQLRNNR (8/7/2015)


    Mood

    🙂 Smiley

    Happy

    Shiny

    reflective

    pensive

    Deep

    Wide

    Load

    Reload

    Download

    Virus

    Exploit

  • RE: Today's Random Word!

    djj (8/10/2015)


    Ed Wagner (8/10/2015)


    BL0B_EATER (8/10/2015)


    Stuart Davies (8/10/2015)


    TomThomson (8/9/2015)


    SQLRNNR (8/8/2015)


    Ed Wagner (8/8/2015)


    Eirikur Eiriksson (8/8/2015)


    SQLRNNR (8/7/2015)


    Mood

    🙂 Smiley

    Happy

    Shiny

    reflective

    pensive

    Deep

    Wide

    Load

    Reload

Viewing 15 posts - 5,461 through 5,475 (of 9,399 total)