Forum Replies Created

Viewing 15 posts - 47,671 through 47,685 (of 59,102 total)

  • RE: Extreme long UPDATE action, advice needed.

    FreeHansje (10/21/2008)

    Something funny is going on, I have to go deeper into this.

    Jeff, the statement is as given in my first post. I get about 13000 1-row-effected messages in my...

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

    October 21, 2008 at 5:10 am

    #887515

  • RE: Who Wants to Be Rich?

    See? What a rich man I am to have such good friends as Barry. We've had more darned fun on these forums.

    Thanks for the laugh, Barry. 🙂

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

    October 20, 2008 at 11:45 pm

    #887426

  • RE: Who Wants to Be Rich?

    rbarryyoung (10/20/2008)

    Jeff Moden (10/20/2008)

    Heh... which definition of "diatribe" do you mean here? 😛

    1 archaic : a prolonged discourse

    2: a bitter and abusive speech or writing

    3: ironic or satirical criticism

    ... ...

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

    October 20, 2008 at 11:12 pm

    #887419

  • RE: user tables and data types

    tjm (10/20/2008)

    Yes. I can see the max_length, but not data_types? Any suggestions?

    SELECT * FROM Information_Schema.Columns

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

    October 20, 2008 at 8:07 pm

    #887398

  • RE: Query Analyzer sends 'Results to File'

    Nikhil Shikarkhane (10/20/2008)

    I dont know what are you using the file for but you can also use sp_send_dbmail to query output into a flatfile

    and have it comma separated cause using...

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

    October 20, 2008 at 7:26 pm

    #887392

  • RE: SQL Server 2000

    Nicely done, Greg. And, if you want the date/time to change no matter which column is updated, just remove the IF...

    CREATE TRIGGER tr_your_trigger_name

    ON [YourTable]

    FOR INSERT,UPDATE

    AS

    IF @@ROWCOUNT = 0 RETURN

    ...

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

    October 20, 2008 at 7:11 pm

    #887390

  • RE: Extreme long UPDATE action, advice needed.

    FreeHansje (10/20/2008)

    I'm not sure how many actual updates have been done, since I get an update result for each individual update; a guestimate makes me believe there are about 13000...

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

    October 20, 2008 at 7:04 pm

    #887389

  • RE: The Financial Crisis

    Heh... I'm not a religious man, but what ever happened to following the original 10 laws? They're well written and cover, quite literally, a wealth of sins. 😉

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

    October 20, 2008 at 7:01 pm

    #887388

  • RE: Clustered index seek is ver very slow

    I'd seriously consider doing some DB and disk maintenance... I don't let the Scan Density get below 90% before I do a rebuild, especially if the clustered index isn't chronological...

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

    October 20, 2008 at 6:55 pm

    #887386

  • RE: Query Analyzer sends 'Results to File'

    If you have the file open with something when you try to do the run, you will get an error like you did.

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

    October 20, 2008 at 6:45 pm

    #887384

  • RE: Who Wants to Be Rich?

    Steve Jones - Editor (10/20/2008)

    Interesting comments, and no complaints, Jeff. Just wondering. Usually I get a good diatribe if I've stoked your interest.

    Heh... which definition of "diatribe" do you mean...

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

    October 20, 2008 at 6:44 pm

    #887383

  • RE: Test-Driven Development of T-SQL Code

    I agree with the problems that the folks in the posts above have cited. Further, there is an absolutely glaring problem with this method (no fault of the author)...

    "refactor...

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

    October 20, 2008 at 5:46 am

    #887062

  • RE: Who Wants to Be Rich?

    Steve Jones - Editor (10/19/2008)

    That's it? I wear you two out on the Financial Crisis poll 🙂

    Heh... the one time I agree with anybody 100% and you ask if "That's...

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

    October 20, 2008 at 5:13 am

    #887059

  • RE: Help Needed with TSQL

    Prakash.Padmanabha (10/19/2008)

    Hi,

    I am recently into SQL Server programming and assuming we need a single row for each line, I have written this query which is giving the results as...

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

    October 19, 2008 at 10:23 am

    #886881

  • RE: Who Wants to Be Rich?

    Exactly... 😉

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

    October 18, 2008 at 6:49 pm

    #886825

Viewing 15 posts - 47,671 through 47,685 (of 59,102 total)