Forum Replies Created

Viewing 15 posts - 26,281 through 26,295 (of 59,102 total)

  • RE: Reporting Row Order

    Erin Ramsay (8/5/2013)

    Good thing I fixed it.. thanks folks.

    The problem was the lowest level nesting order wasn't set.

    I'm thinking that this isn't a very common problem and that's why no...

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

    August 5, 2013 at 8:22 pm

    #1638781

  • RE: Changing SQLServerCentral - Initial Thoughts

    I cannot speak for others but, despite its age, I've always thought that SSC was a very rich looking and colorful site (right down to the unique and colorful icons...

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

    August 5, 2013 at 6:45 pm

    #1638776

  • RE: Run at Certain Time of Morning

    OldSageMonkey (8/5/2013)

    Hi All,

    Im trying to add a check to see what time it is in the morning before my stored procedure runs

    Why? I might be missing something here but...

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

    August 5, 2013 at 4:55 pm

    #1638770

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/5/2013)

    GilaMonster (8/5/2013)

    Steve Jones - SSC Editor (8/5/2013)

    GilaMonster (8/5/2013)

    andrew gothard (8/5/2013)

    ... Remember being able to PIN TABLE ...

    :exclamation: you have no idea how happy I am...

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

    August 5, 2013 at 3:30 pm

    #1638754

  • RE: Are the posted questions getting worse?

    GilaMonster (8/5/2013)

    Jeff Moden (8/5/2013)

    Won't Hekaton allow you to use more memory than you should?

    I don't know what the memory management's going to be, there's no info available on it yet.

    Hekaton...

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

    August 5, 2013 at 3:28 pm

    #1638752

  • RE: Are the posted questions getting worse?

    I agree that, like anything else, pinned tables could be abused for all the wrong reasons. We used it as a temporary measure to get out of the woods...

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

    August 5, 2013 at 2:14 pm

    #1638731

  • RE: Are the posted questions getting worse?

    GilaMonster (8/5/2013)

    Jeff Moden (8/4/2013)

    Remember being able to PIN TABLE and then took that wonderful feature away? Now they're bringing a form of it back with Hekaton but with more...

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

    August 5, 2013 at 1:51 pm

    #1638725

  • RE: Sorting Months By Number (SQL Spackle)

    Brad Schulz (8/5/2013)

    Hi Jeff...

    I appreciate you doing the time tests. Obviously I have to eat my words talking about "half the CPU". When I did comparisons between what...

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

    August 5, 2013 at 12:35 pm

    #1638701

  • RE: Sorting Months By Number (SQL Spackle)

    pierre-702284 (8/5/2013)

    Thanks for including my solution in the test results 🙂 I know it's not the fastest but it feels more "real world" because you usually need to take 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)

    August 5, 2013 at 12:30 pm

    #1638698

  • RE: Top from store procedure

    Erland Sommarskog (8/4/2013)

    Jeff Moden (8/3/2013)

    Just remember that SET ROWCOUNT is a deprecated feature and, according to the 2012 deprecation list, is scheduled to go away in the next version 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)

    August 4, 2013 at 5:28 pm

    #1638504

  • RE: Loading Hierarchical data

    Understood. Thanks for the update especially on the desired results. I have to prep for work tomorrow so I can't guarantee that I can get to this tonight...

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

    August 4, 2013 at 5:15 pm

    #1638503

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (8/4/2013)

    L' Eomot Inversé (8/4/2013)

    Maybe I'm committing an egregious social error by raising something technical in this forum, but sometimes I thing deprecation lists are at least as political...

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

    August 4, 2013 at 12:37 pm

    #1638491

  • RE: Top from store procedure

    Naveen PK (8/4/2013)

    Try use CTE and select top 10 from cte. I did not test this myself but believe it should work.

    How would you use the output of a stored...

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

    August 4, 2013 at 8:11 am

    #1638480

  • RE: Loading Hierarchical data

    Nagaram (8/4/2013)

    Thanks for you query, but it is not giving the correct Parent_ID if I add more rows under category 2(or any) to the temp table ..

    SELECT 2,'104','c','cc','ccc','cccc' ,...

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

    August 4, 2013 at 8:03 am

    #1638478

  • RE: nvarchar(max) or nvarchar(1000)?

    There might actually be a drawback to switching NVARCHAR to VARCHAR depending on which ORM you're using. For example, Linq2SQL would usually send string parameters with the "N" prefix...

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

    August 3, 2013 at 8:01 pm

    #1638472

Viewing 15 posts - 26,281 through 26,295 (of 59,102 total)