Forum Replies Created

Viewing 15 posts - 52,876 through 52,890 (of 59,072 total)

  • RE: Query for work shift differential

    Heh... understood and thanks...

    Becareful, though, Sam... one of the things that an Execution Plan will do, is "lie"... frequently, it can't "see" past the first row of the correlated sub-query...

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

    January 16, 2008 at 7:49 am

    #768665

  • RE: Performance of Scripts in SQL Server 2000

    Heh... spot on, Matt... Just like you did, I load what I call a "discovery load". The only difference is that I don't even take the time to change...

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

    January 16, 2008 at 7:40 am

    #768657

  • RE: SQL - Derived Tables

    jldsql (1/16/2008)

    Microsoft documentation suggest that both derived tables and temporary table will first use memory cache if available.

    Jim

    Jim... First, I absolutely agree with what you said... But, I also...

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

    January 16, 2008 at 7:24 am

    #768640

  • RE: Performance of Scripts in SQL Server 2000

    Shaun McGuile (1/16/2008)

    Sorry - had not read all of the posts before posting!:rolleyes:

    --Shaun

    Heh! Man, I had to laugh out loud! I've done that many times myself... it's normally...

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

    January 16, 2008 at 7:15 am

    #768635

  • RE: New Company, new DBA Tools budget, can you recommend any?

    Paul Bakker (1/16/2008)

    Does anyone have experience with the freeware version of SqlSafe? Can this product safely used in a production enviroment?

    Heh... freeware...

    My recommendation is that you read the license...

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

    January 16, 2008 at 7:12 am

    #768634

  • RE: Query for work shift differential

    Samuel Vella (1/16/2008)

    Jeff,

    (Did you miss my earlier posts?)

    Case would be a lot easier for very simple examples but sometimes @nbr is derived and for clarity/optimization it would be better to...

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

    January 16, 2008 at 6:58 am

    #768625

  • RE: SQL - Derived Tables

    Hey Prashant...

    You remember I said "don't let it dampen your writing spirit"? Here's why... like I said, you have some good information in your article and people have already...

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

    January 16, 2008 at 6:43 am

    #768610

  • RE: SQL - Derived Tables

    ...and everything happens in memory instead of a combination of memory and disk.

    ...while a temporary table exists until the server is brought down and also it uses lot of disk...

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

    January 16, 2008 at 12:44 am

    #768480

  • RE: Exporting to a fixed length FF with varying record lengths

    You bet, Jeremy... thanks for the feedback. Just remember... if you have lots of data, BCP with a format file will absolutely scream compared to this concatenation 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)

    January 16, 2008 at 12:27 am

    #768479

  • RE: Performance of Scripts in SQL Server 2000

    Crud... guess I need to start another rant! This forum won't allow me to post a "backslash-n" even in the code window. Line 188 of the BCP format...

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

    January 16, 2008 at 12:16 am

    #768476

  • RE: Performance of Scripts in SQL Server 2000

    Well.... I should have known better... as soon as I saw that it was a Government agency, I should have known that the record layout they provided wasn't going to...

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

    January 16, 2008 at 12:08 am

    #768474

  • RE: Tracking Illicit Users

    David.Poole (1/15/2008)

    LICH (1/15/2008)

    Also "Analyser" should be "Analyzer"

    Not if you're British it shouldn't.

    Well, at least not until we've had a couple of "P's & Q's" 😀 Got beer? :w00t:

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

    January 15, 2008 at 7:12 pm

    #768433

  • RE: Some are just awful...

    Of course... but I guess I'd rather keep it professional (or at least try to salvage some semblance of professionalism on my part after my initial outburst) by not citing...

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

    January 15, 2008 at 7:05 pm

    #768430

  • RE: returning data for a given month

    That would be the one... they're pretty smart making it a new datatype... will actually keep 23:59:59.997 code from breaking... unless it's used on the wrong column type.

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

    January 15, 2008 at 5:57 pm

    #768419

  • RE: LTRIM linked field

    Heh... glad someone occasionally gets a laugh out of those... 😛

    More on the serious side... the "Bat with a nail in it" is actually a metaphore for what I do...

    I'll...

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

    January 15, 2008 at 5:24 pm

    #768414

Viewing 15 posts - 52,876 through 52,890 (of 59,072 total)