Forum Replies Created

Viewing 15 posts - 18,766 through 18,780 (of 59,098 total)

  • 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

  • RE: Is BCP queryout limited?

    dwilliscp (12/30/2015)

    Jeff Moden (12/29/2015)

    dwilliscp (12/29/2015)

    I would love to post the code.. but it is my vendor's code... sorry.

    Actually, that explains a lot.

    So who's code is it that's in your first...

    --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 8:10 am

    #1848763

  • RE: Create temporary table from output of dynamic SQL

    sandesh_krishnan (12/30/2015)

    Hi,

    Is there an option to create a temporary table based on the output of dynamic SQL?

    Example : 'Select * Into #TEMP_TABLE FROM '+ DYNAMIC_SQL

    I have tried option 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)

    December 30, 2015 at 7:57 am

    #1848754

  • RE: Covert columns to rows

    kaza.rohan (12/30/2015)

    Can we write dynamically for sys.databases , is there any possibility ?

    But for other tables it is possible by using sys.columns and then we can unpivot it.

    but sys.databases 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)

    December 30, 2015 at 7:52 am

    #1848751

  • RE: how does datatypes get set when using select into in sql server?

    dndaughtery (12/30/2015)

    There aren't any mathematical calculations but there are several Case statements. I'd post the query but its a monster

    CASE [font="Arial Black"]IS [/font]a type of calculation. You may have...

    --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 7:47 am

    #1848750

Viewing 15 posts - 18,766 through 18,780 (of 59,098 total)