Forum Replies Created

Viewing 15 posts - 54,106 through 54,120 (of 59,072 total)

  • RE: Recursive query for a Bill of Materials table

    That KB article is what you'll find in BOL under "Expanding Hierarchies"...

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

    November 15, 2007 at 5:31 am

    #751455

  • RE: help me...

    Jason Selburg (11/14/2007)

    Sorry everybody, but dewa's already said it's in Simple mode. :crying:

    Yeah, I missed that. Oh well... at least Dewa has the links for a recovery using FULL......

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

    November 15, 2007 at 5:18 am

    #751451

  • RE: is there any difference between != and <>

    ==============================================================================

    Matt's CLR Solution for Extracting Phone Numbers

    ------------------------------------------------------------------------------

    (4040205 row(s) affected)

    00:01:46:083 Duration (hh:mi:ss:mmm)

    ==============================================================================

    Ok... I might have just missed in in your code and because of the rowcount you have (I know...

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

    November 14, 2007 at 7:47 pm

    #751347

  • RE: is there any difference between != and <>

    --the unique index - not clustered since you're not doing clustered either

    Boy! Talk about a typo on my part :sick:

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

    November 14, 2007 at 6:18 pm

    #751324

  • RE: is there any difference between != and <>

    GilaMonster (11/14/2007)

    Or if Jeff wants to produce the T-SQL, I can give the C# a try, but it won't be for a couple days.

    Heck ya... great idea for a test,...

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

    November 14, 2007 at 6:00 pm

    #751320

  • RE: is there any difference between != and <>

    Shaun McGuile (11/14/2007)

    Good idea Gail, I'm not gonna get in the way of battling giants!:D

    Matt said it right... "boys with their toys"... just having a bit of fun... c'mon in......

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

    November 14, 2007 at 5:55 pm

    #751316

  • RE: can I Shrink the database?

    KT (11/14/2007)

    keep in mind that this is a DL380 and E is currently over 550GB so would this additional space be for moving E or would it be simply adding...

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

    November 14, 2007 at 5:50 pm

    #751314

  • RE: is there any difference between != and <>

    Heh... you've hit SQL Server in it's weak spot... RegEx... I know that's what you'll build into your CLR and I've got a funny feeling I'm going to get my...

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

    November 14, 2007 at 3:10 am

    #751005

  • RE: unexplained database growth

    In the moving of the data I forgot a job that deleted from 1 table, so in a weeks time this table became hugh.

    So... you all set now?

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

    November 13, 2007 at 11:57 pm

    #750966

  • RE: help me...

    Okidoki... I'm not a "Systems DBA" so anything I'd say would probably be wrong on this... so the following URL's are the step by step instructions on how to do...

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

    November 13, 2007 at 11:43 pm

    #750959

  • RE: help me...

    Data might not be gone if the database is in the "FULL RECOVERY" mode... can you check, please? Don't do a recovery, just yet...

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

    November 13, 2007 at 11:32 pm

    #750958

  • RE: INSERT A Record Based on Count

    Absolutely! And to be fair, it IS a really extreme example... but put both pieces of code in a single QA window and run an estimated execution plan on...

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

    November 13, 2007 at 10:24 pm

    #750927

  • RE: INSERT A Record Based on Count

    Actually - did you see my last post? Execution plan-wise, and processor effort-wise, CTE seems to be the "better choice".

    Heh... they ALL say that until a job takes 8...

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

    November 13, 2007 at 9:40 pm

    #750920

  • RE: is there any difference between != and <>

    I'll pick up that gauntlet.. How about we up the ante a little. Split the string, return the PK, the split value AND the index in the original string....

    Heh......

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

    November 13, 2007 at 8:56 pm

    #750916

  • RE: INSERT A Record Based on Count

    but we have others who are about to (use this to "gut" CTE's).

    Like me! 😀

    Heh... I don't need this thread to gut CTE's... most code examples that use them in...

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

    November 13, 2007 at 5:58 pm

    #750899

Viewing 15 posts - 54,106 through 54,120 (of 59,072 total)