Forum Replies Created

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

  • RE: Setting multiple values

    ksullivan (3/30/2008)

    What you want to do is not directly possible.

    Heh... not quite true... 😉 And the Tally Table method always wins the race when it comes to 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 9:34 pm

    #796273

  • RE: Splitting Table Column on Delimiter

    CROSS APPLY = CORRELATED SUBQUERY

    CORRELATED SUBQUERY = RBAR

    RBAR + UDF + TABLE VARIABLE = S....L....O....W

    Heh... Lowell!!! :blink: You of all people should know that the Tally Table method...

    --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 9:03 pm

    #796264

  • RE: Any good online tutorials to practice joins/selects etc?

    Adam Haines (3/31/2008)

    A pretty good source is w3schools. This site offers lots of differnent tutorials and practices, with easy to understand examples.

    http://www.w3schools.com/sql/default.asp

    Yeah... just remember... that's not T-SQL... and 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)

    March 31, 2008 at 8:05 pm

    #796252

  • 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 8:00 pm

    #796251

  • 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

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