Forum Replies Created

Viewing 15 posts - 54,796 through 54,810 (of 59,072 total)

  • RE: Is this workable

    GilaMonster (9/29/2007)

    MSDB is a perfect example of how not to design a database. Every time I have to get data from that DB I end up tearing more hair out....

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

    September 29, 2007 at 9:11 pm

    #737458

  • RE: Remove Decimals Without Rounding

    Did someone say "loop"??? :blink: On a single row????? :sick:

    Using a previous example where 5 decimal places are required to be padded with zeros...

    DECLARE @i DECIMAL(10,5)

    SET...

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

    September 29, 2007 at 9:06 pm

    #737456

  • RE: Update Trigger Updates Correct Record In Another Table

    Sorry... temporarily lost my mind... I meant CreatedBy and CreatedOn... not "Modified". 🙂

    You think it's better to store all data twice on insert?... Once "normal sized" in the 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)

    September 29, 2007 at 8:53 pm

    #737452

  • RE: Limit Resources to UGLY query

    Thanks, Bob...

    First, updating 500K or even a million rows in a single update probably isn't a problem... 20 million is a problem. If you do some testing, I think...

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

    September 29, 2007 at 4:20 pm

    #737430

  • RE: Unique ID for a View

    Hold on.... let me get my pen and write this one down in my "Why I don't let developers design views" book 😀

    Why do you need a unique ID 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)

    September 29, 2007 at 4:08 pm

    #737426

  • RE: Data in Use or Data in memory

    It was removed because it was a really bad idea...;)

    Like I said, stop trying to decrypt the whole table... encrypt the lookup criteria and do a normal join or WHERE...

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

    September 29, 2007 at 4:01 pm

    #737425

  • RE: Remove Decimals Without Rounding

    Why do you think you need the extra overhead of RTRIM/LTRIM when converting Decimal to Varchar?

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

    September 29, 2007 at 3:56 pm

    #737424

  • RE: Reading Variable Flat File

    Heh... why sure, Remi... just look at the difficulties Steve is having trying to fix some of the problems with this "forum in a can" code that RedGate bought. ...

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

    September 29, 2007 at 3:54 pm

    #737423

  • RE: Is this workable

    Sure... somehow they managed to save trailing spaces in NVARCHAR columns... Use DATALENGTH to check... some of the columns are defined as 100 characters wide... and even if they only...

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

    September 29, 2007 at 3:51 pm

    #737421

  • RE: Tempdb Contention

    GilaMonster (9/29/2007)

    TempDB has a DBID of 2, always.

    Teaching how to fish... 😉

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

    September 29, 2007 at 3:45 pm

    #737420

  • RE: Tempdb Contention

    noeld (9/28/2007)

    ... Running sp_HelpDB will allow you to figure out the DBID ...

    select db_name(dbid)

    Cheers,

    Heh... yeah... that'll work if you know the DBID... won't help you find the DBID 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)

    September 29, 2007 at 3:40 pm

    #737419

  • RE: Update Trigger Updates Correct Record In Another Table

    Ninja's_RGR'us (9/29/2007)

    Just one question on that Jeff. How do you track the information of When, what, who inserted the original row?

    I know this data should be kept separate from...

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

    September 29, 2007 at 3:34 pm

    #737418

  • RE: Update Trigger Updates Correct Record In Another Table

    Phil Factor (9/11/2007)

    is a popular introductory article on the technique

    Well, I'll be damned... Now I know who to blame... 😀 (NOT Phil... Pop Rivet!)

    I've had a bit...

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

    September 29, 2007 at 10:47 am

    #737397

  • RE: Limit Resources to UGLY query

    Hi Bob...

    Just confirming... how many rows does the following update?

    4) The _Change fields would be the difference between the day before and the current day for the specific type. 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)

    September 29, 2007 at 10:03 am

    #737395

  • RE: Unique ID for a View

    In that article, the part that would work for a view looks like this...

    SELECT emp_id, lname, fname, job_id,

    (SELECT COUNT(*) FROM employee e2 WHERE e2.emp_id <= e.emp_id AND e2.job_id =...

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

    September 28, 2007 at 8:59 am

    #737145

Viewing 15 posts - 54,796 through 54,810 (of 59,072 total)