Forum Replies Created

Viewing 15 posts - 18,736 through 18,750 (of 59,072 total)

  • RE: Decorations

    TomThomson (12/31/2015)

    What am awful article. The idea or putting code into some ghastly image format so that no-one can copy i and run it through whatever analysis tools they...

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

    January 1, 2016 at 6:29 pm

    #1849044

  • RE: The Most Common Query Blunders...

    Heh... without going into too many details, I've found that one of the most common query blunders is the nearly religious belief in rote, so called "best practices" and some...

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

    January 1, 2016 at 6:01 pm

    #1849043

  • RE: query for datetime

    drew.allen (12/31/2015)

    Jeff Moden (12/30/2015)

    Here's the code I wrote last night with the validation checks that I added today. Details are in the comments in the code.

    GREAT! But suppose your...

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

    January 1, 2016 at 5:13 pm

    #1849042

  • RE: query for datetime

    Eirikur Eiriksson (12/31/2015)

    Careful here Jeff, the type cast to decimal is expensive, consider using float which does not need a type cast is less costly.

    Understood. FLOAT only has a...

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

    January 1, 2016 at 5:09 pm

    #1849041

  • RE: Another Recursive Hierarchy bit of help needed...

    simon_s (12/31/2015)

    one thing I have noticed so far is with just 215 rows in the table its taking over 30 minutes so far to run...

    You have a loop somewhere 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)

    January 1, 2016 at 4:59 pm

    #1849040

  • RE: Page split with Clustered index

    I know this thread is over 5 years old but I believe I found out why page splits occur even in the case of ever increasing values during inserts. ...

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

    December 31, 2015 at 6:48 pm

    #1849001

  • RE: query for datetime

    Alright... it looks like Drew isn't going to bite on this one.

    Here's the code I wrote last night with the validation checks that I added today. Details...

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

    December 30, 2015 at 11:12 pm

    #1848885

  • RE: query for datetime

    FridayNightGiant (12/30/2015)

    Thought I would have a go at your challenge Jeff, just for fun as it is quiet in work.

    Looking forward to any critiques - not sure if 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)

    December 30, 2015 at 9:33 pm

    #1848883

  • RE: The Most Common Query Blunders...

    MMartin1 (12/30/2015)

    Jeff Moden (12/25/2015)

    I believe my favorite non-SARGable problems are due to the inappropriate use of "OR" and things like the following...

    WHERE ISNULL(SomeNumericColumn,0) > 0

    ...

    WHERE ISNULL(SomeCharacterColumn,'...

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

    December 30, 2015 at 4:21 pm

    #1848866

  • RE: Number VS Letter

    So let's get back to the burning question...

    @Basurmanin,

    Why the restrictions other than someone told you so?

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

    December 30, 2015 at 4:16 pm

    #1848865

  • RE: query for datetime

    drew.allen (12/30/2015)

    Jeff Moden (12/30/2015)

    Generating data to the ms across a large range of dates is very important to testing.

    I would say that depends on what you're testing and...

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

    December 30, 2015 at 3:44 pm

    #1848862

  • RE: Help with a query, plz

    SQLisAwE5OmE (12/30/2015)

    Jeff Moden (12/30/2015)

    SQLisAwE5OmE (12/30/2015)

    I tried to include the CATEGORY field to the script Jeff provided and it seems working, but my only concern is, this doesn't pull the parent2...

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

    December 30, 2015 at 1:58 pm

    #1848839

  • RE: query for datetime

    drew.allen (12/30/2015)

    Jeff Moden (12/29/2015)

    And, no... I'm not being snarky here. I'd really like to see how others would do this using only the methods you speak of. I'll...

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

    December 30, 2015 at 12:51 pm

    #1848827

  • RE: Is BCP queryout limited?

    So, just to be clear.... you no longer have the original "identifier" problem?

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

    December 30, 2015 at 12:38 pm

    #1848823

  • RE: Help with a query, plz

    SQLisAwE5OmE (12/30/2015)

    I tried to include the CATEGORY field to the script Jeff provided and it seems working, but my only concern is, this doesn't pull the parent2 field....as my original...

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

    December 30, 2015 at 12:32 pm

    #1848820

Viewing 15 posts - 18,736 through 18,750 (of 59,072 total)