Forum Replies Created

Viewing 15 posts - 26,101 through 26,115 (of 59,102 total)

  • RE: Slow performance on a very small SP that updates a very small table

    There's one other thing that you might actually want to add to the proc if it's ever used by ccalls from the front end.

    SET NOCOUNT ON;

    That will keep...

    --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 25, 2013 at 2:16 pm

    #1644745

  • RE: CTE to determine Course Level

    pietlinden (8/25/2013)

    LOL, thanks.

    The funny thing was that I figured it out after posting a couple of times. I guess posting forces me to re-read a bunch of my code...

    --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 25, 2013 at 2:11 pm

    #1644743

  • RE: Another Duplicate removal question

    Lynn Pettis (8/25/2013)

    Jeff Moden (8/24/2013)

    I can't help with requirement #2 because I don't know what your data or table looks like and don't know what exactly you mean by "preferably...

    --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 25, 2013 at 2:08 pm

    #1644741

  • RE: Logic to break period of time by month

    mario17 (8/25/2013)

    Thanks, Jeff

    I just started to go into CROSS APPLY, being a JOIN person I'm trying to translate in into join, and still can't make it work as in 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)

    August 25, 2013 at 11:19 am

    #1644726

  • RE: NULL issue

    Erland Sommarskog (8/25/2013)

    Jeff Moden (8/24/2013)

    We have to be a little careful here. The default for the setting at the database connection level is OFF and the default setting for...

    --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 25, 2013 at 11:02 am

    #1644725

  • RE: Question on pivot tables

    johnabraham1980 (8/24/2013)

    use below syntax for pivot table in sql

    SELECT <non-pivoted column>,

    [first pivoted column] AS <column name>,

    [second pivoted column] AS <column name>,

    .............................

    FROM

    (<SELECT query that produces the data>)

    AS <alias for 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 25, 2013 at 10:25 am

    #1644719

  • RE: CTE to determine Course Level

    Heh... it's almost a shame that you figured it out on your own because, except for a couple of foreign key errors, you did such a nice job posting 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 25, 2013 at 9:55 am

    #1644715

  • RE: NULL issue

    We have to be a little careful here. The default for the setting at the database connection level is OFF and the default setting for connections within SSMS 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)

    August 24, 2013 at 9:25 pm

    #1644700

  • RE: Performance difference between using a transaction and not using a transaction

    GilaMonster (8/24/2013)

    Jeff Moden (8/24/2013)

    the data isn't actually written as you would think until the transaction is committed.

    In both cases the data changes are made to pages in memory and those...

    --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 24, 2013 at 8:18 pm

    #1644698

  • RE: new to everything sql

    If I were just starting out in this field today, I'd be asking the same questions. I was fortunate to be an "accidental DBA" starting back circa 1996 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)

    August 24, 2013 at 7:57 pm

    #1644697

  • RE: Capacity Planning

    @SQLFRNDZ (8/24/2013)

    Thank you Jeff, definitely helps.

    In addition,I was thinking of a load test resource bottlenecks before going to live with some software which can create the virtual users, For example...

    --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 24, 2013 at 6:47 pm

    #1644696

  • RE: Are the posted questions getting worse?

    dwain.c (8/23/2013)

    Jeff Moden (8/23/2013)

    Sean Lange (8/22/2013)

    Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging...

    --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 24, 2013 at 6:35 pm

    #1644695

  • RE: Are the posted questions getting worse?

    Sean Lange (8/23/2013)

    Jeff Moden (8/23/2013)

    Sean Lange (8/22/2013)

    Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low...

    --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 24, 2013 at 6:34 pm

    #1644694

  • RE: Physical Security

    One of the other possible security problems is with the janitorial and repair staff. They have the keys and RFIDs to get just about anywhere. They might not...

    --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 24, 2013 at 6:15 pm

    #1644693

  • RE: Another Duplicate removal question

    I can't help with requirement #2 because I don't know what your data or table looks like and don't know what exactly you mean by "preferably the one with 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 24, 2013 at 6:02 pm

    #1644692

Viewing 15 posts - 26,101 through 26,115 (of 59,102 total)