Forum Replies Created

Viewing 15 posts - 51,406 through 51,420 (of 59,098 total)

  • RE: Training Programmers: Accessing Base Tables or Stored Procs

    Matt Miller (3/31/2008)

    Jeff Moden (3/29/2008)

    Well said. I especially like the two rules because, if you substitute the word "RBAR" for "Cursor", I use them all the time in 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)

    March 31, 2008 at 7:52 pm

    #796250

  • RE: Writing Faster T-SQL

    srienstr (3/31/2008)

    Daniel Wilson (5/22/2007)

    thanks for the intro to CTE's! I know I've written the same SELECT statement into 2 parts of a query before. No more ... ah...

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

    March 31, 2008 at 7:39 pm

    #796249

  • RE: PK / FK design question

    Thanks John G... and spot on... the hard part most certainly is getting developers and designers to think in correct set based frames of mind... Sometimes that even includes SQL...

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

    March 31, 2008 at 7:33 pm

    #796248

  • RE: Training Programmers: Accessing Base Tables or Stored Procs

    Wayne West (3/31/2008)

    I agree, performance isn't as big of a deal as it was back in 4.x/6.5 days.

    Perfect... everyone keep thinking that way... keeps me employed fixing performance problems...

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

    March 31, 2008 at 7:24 pm

    #796245

  • RE: CLR Code to run Generic Command Prompt Commands

    rbarryyoung (3/30/2008)

    Given that Windows account delegation is not an acceptable approach for the general case (and it isn't, but that's a different discussion), the only other cost-effective thing that you...

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

    March 31, 2008 at 7:18 pm

    #796243

  • RE: cursor to identify changed,deleted and added records

    Robert (3/31/2008)

    What does "OP" stand for? Ops, original poster :blush:

    Considering the level of the question, I wouldn't think so either. However, when dealing with customers or assisting fellows developers on...

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

    March 31, 2008 at 7:06 pm

    #796239

  • RE: When to use a cursor

    Buxton69 (3/31/2008)

    Could you point me toward a good resource for examples of code without using cursors, I have some examples where you load a select statement into a temp table...

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

    March 31, 2008 at 7:03 pm

    #796237

  • RE: Could I eliminate this cursor?

    escaleraroyal (3/31/2008)

    go some data

    Party table

    -----------------------------------------

    instrument_id party_id last_name first_name middle_name name_suffix

    31966558329324CLUBBSTACYL

    331891810350608CROOKE,BESSIE J EST

    331891810350858JACKSONLLOYDD

    output

    -------------------

    instrument_idparty_idsort_orderparty_data

    319665583293241(I) CLUBB, STACY L

    3318918103506082(I) CROOKE,BESSIE J EST

    3318918103508583(I) JACKSON, LLOYD D

    Is there a question that goes along with this...

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

    March 31, 2008 at 6:56 pm

    #796235

  • RE: IF (COLUMNS_UPDATED()) ???

    AlexSQLForums (3/31/2008)

    Thanks for input everyone

    I used:

    if update (columnname) or update(columnname) or update (columnname)

    begin

    --sql statements

    end

    and it worked

    Thanks for posting your solution, Alex!

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

    March 31, 2008 at 6:51 pm

    #796234

  • RE: Database Growth

    Cory Ellingson (3/27/2008)

    I just checked the SQL Log File Viewer, and I see auto grows being logged..

    Is this what you are looking for?

    Cory... I've not had to use the SQL...

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

    March 31, 2008 at 6:40 pm

    #796231

  • RE: Database Growth

    Thanks, Brian...

    Just so everyone knows, sp_track_db_growth does not even come close to what the OP asked for. Rather, it tracks what size the backup files are. It does...

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

    March 31, 2008 at 6:13 pm

    #796227

  • RE: Need help on small project from SQL professional

    He's all your's, Barry 😉 Send him an email 🙂

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

    March 31, 2008 at 5:08 pm

    #796212

  • RE: Database Growth

    Babu_Raj (3/31/2008)

    EXEC sp_track_db_growth

    GO

    I agree... such a sproc is NOT provided by MS in any installation of SQL Server 2000... would you post the code for this sp_track_db_growth sproc 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)

    March 31, 2008 at 5:06 pm

    #796211

  • RE: String Replacement using Table Values

    ... and, no matter how you shape it, a cursor or While Loop is going to kill performance.

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

    March 31, 2008 at 5:02 pm

    #796209

  • RE: Long Distance Backups

    Heh... understood. Been there and done that. Not fun no matter which way you do it.

    I agree with most of the others... log shipping is probably the best...

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

    March 31, 2008 at 4:58 pm

    #796207

Viewing 15 posts - 51,406 through 51,420 (of 59,098 total)