Forum Replies Created

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

  • 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

  • RE: Problems with a dynamic function

    kevins-1001299 (6/20/2013)

    Performance, though, is not a top priority at this time. Sometime in the distant future, I'm sure it will be a much bigger priority.

    BWAA-HAAA!!!!! Being a DBA 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)

    August 3, 2013 at 7:14 pm

    #1638470

  • RE: Tsql to calculate workdays - holidays: for current month

    David Smerchek (6/19/2013)

    SELECT DATEDIFF (day, Convert(Varchar(11),DATEADD(d,-(DAY(getdate())-1),getdate()),110), Convert(varchar(11),GETDATE(),110))

    - (2 * DATEDIFF(week, Convert(Varchar(11),DATEADD(d,-(DAY(getdate())-1),getdate()),110), Convert(varchar(11),GETDATE(),110)))

    - CASE WHEN DATEPART(weekday, DATEADD(d,-(DAY(getdate())-1),getdate()) + @@DATEFIRST) = 1 THEN 1 ELSE 0 END - CASE WHEN DATEPART(weekday,...

    --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 6:52 pm

    #1638469

  • RE: Add one MilliSecond to each row

    dwain.c (7/28/2013)

    May I ask why you need to add 1 millisecond to each row?

    In other words, what is the problem you're facing when all of the bulk insert CreatedDates are...

    --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 6:40 pm

    #1638466

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