Forum Replies Created

Viewing 15 posts - 24,031 through 24,045 (of 59,099 total)

  • RE: How efficiently delete the old data?

    ananda.murugesan (3/29/2014)

    How efficiently delete old data for purging older than last 5 years data

    Batch Delete Loops aren't "efficient". Large singleton deletes aren't "efficient". Deletes in general, aren't "efficient"....

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

    March 29, 2014 at 9:03 pm

    #1701406

  • RE: RecursiveHierarchyCTE

    Lynn Pettis (3/29/2014)

    kevin_nikolai (3/28/2014)

    Hi Sean, I managed to create scripts which only includes the very minimum records, therefore no need to compress them. Attached the 3 scripts. First script is...

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

    March 29, 2014 at 8:47 pm

    #1701403

  • RE: Parsing XML Blob

    You should write another article, Eirikur. One on the very techniques that you've exposed in this thread. I was pretty sure that problem in the original post was...

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

    March 29, 2014 at 3:26 pm

    #1701389

  • RE: how to Create index online?

    tlunsf (3/28/2014)

    Ninja's_RGR'us (5/26/2011)

    What didn't you understand in my previous post?

    What part of ONLINE = SOMETHING OTHER THAN OFF GOES HERE are you having troubles with?

    It is comments like this that...

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

    March 29, 2014 at 8:42 am

    #1701372

  • RE: how to Create index online?

    There are other caveates that will prevent an index from being bilt/rebuilt in an online fashion unless you have 2k14. If the table has blobs in them, then the...

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

    March 29, 2014 at 8:33 am

    #1701371

  • RE: Parsing XML Blob

    Eirikur Eiriksson (3/29/2014)

    elfresco1 (3/26/2014)

    I am having problem trying to parse an XML field in a table because it is too complex for me. I need to get the data from...

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

    March 29, 2014 at 6:53 am

    #1701365

  • RE: Converting sequential time records into IN and OUT times

    Perfect. Thanks for posting that file.

    Ignoring the TimeN and InOut columns that you made, here's the code to pivot (using a CROSSTAB) the pairs of times, calculate the differences...

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

    March 28, 2014 at 11:07 pm

    #1701353

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/28/2014)

    Jeff Moden (3/28/2014)

    GilaMonster (3/28/2014)

    Ed Wagner (3/28/2014)

    Grant - You have booth babes??? :w00t:

    Grant *is* the booth 'babe' 🙂

    Heh... especially on kilt day. 😀

    You have six months,...

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

    March 28, 2014 at 10:11 pm

    #1701350

  • RE: Log file is filling up

    New Born DBA (3/28/2014)

    JoshDBGuy (3/28/2014)

    Initial log file size is 121 MB and the autogrowth is 10 percent which currently equates to about 12 MB. Where do you see 30 GB?

    I...

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

    March 28, 2014 at 11:44 am

    #1701257

  • RE: Trn log backup chain

    Barcelona10 (3/28/2014)

    thank you for replay.How about differential backup chain?.

    Read the article at the link provided in the previous post. 😉

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

    March 28, 2014 at 11:38 am

    #1701253

  • RE: which way is the better for 1 million records inserting into one table

    MyDoggieJessie (3/28/2014)

    Fair point 🙂

    For ease of use, I'd go with BCP. Which would you recommend?

    If there are no "double-hop" or server trust problems for BULK INSERT, I'd go with...

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

    March 28, 2014 at 10:55 am

    #1701228

  • RE: Log file is filling up

    New Born DBA (3/28/2014)

    Jeff Moden (3/28/2014)

    New Born DBA (3/28/2014)

    Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB...

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

    March 28, 2014 at 10:42 am

    #1701216

  • RE: Are the posted questions getting worse?

    GilaMonster (3/28/2014)

    Ed Wagner (3/28/2014)

    Grant - You have booth babes??? :w00t:

    Grant *is* the booth 'babe' 🙂

    Heh... especially on kilt day. 😀

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

    March 28, 2014 at 10:36 am

    #1701215

  • RE: Log file is filling up

    New Born DBA (3/28/2014)

    Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The auto-growth of...

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

    March 28, 2014 at 9:13 am

    #1701173

  • RE: Are the posted questions getting worse?

    SQLRNNR (3/28/2014)

    Sean Lange (3/28/2014)

    dwain.c (3/28/2014)

    Ville-Pekka Vahteala (3/27/2014)

    Luis Cazares (3/27/2014)

    How is it possible that someone writes a cursor instead of using SUM()?

    I'm afraid that this database is full of these pieces...

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

    March 28, 2014 at 8:08 am

    #1701119

Viewing 15 posts - 24,031 through 24,045 (of 59,099 total)