Forum Replies Created

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

  • 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

  • RE: trigger not called for each record?

    Andre T (3/31/2008)

    So, basically, I do need the trigger to call my stored procedure for each item changed.

    Absolutely NOT! That's RBAR on steroids and it will crush any hope...

    --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:54 pm

    #796206

  • RE: Choosing between a View and Table-valued function

    Lots of great ideas on this thead...

    At this point, I'd have to say "it depends"... like has already been said, both UDF's and Views can be written in horribly incorrect...

    --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:49 pm

    #796204

  • RE: Comparing Strings......

    Ahmad Osama (3/27/2008)

    souLTower (3/27/2008)

    If you have a table called CompanyNames you can query like this:

    -- Remember to use procs to eliminate SQL injection

    SELECT cid from CompanyNames where cname = [user...

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

    #795906

  • RE: When to use a cursor

    In almost all cases, neither a cursor nor any form of a While loop are required especially in SQL Server 2005.

    Lots of folks use the guidline "when it can't be...

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

    #795903

  • RE: Output data to a WORD document

    It would be much more effective to output your data to a file and use Word to do a MERGE document.

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

    #795897

  • RE: Transfer data from SQL server database to DBISAM

    Heh... Gail is spot on... and it ticks some of us off so bad, we won't respond with anything useful.

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

    #795895

  • RE: Query Building Tips (Need Them!)

    On the subject of "Derived Tables", look into CTE's... they make for easier to read code and can be self aliased, if need be, without duplicating the "sub-query".

    Also, take 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 6:50 am

    #795893

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