Forum Replies Created

Viewing 15 posts - 53,866 through 53,880 (of 59,072 total)

  • RE: To NULL or not to NULL

    Yeap... even on my 4 year old 1.8GHz desktop... not much of a difference... remember, this is to "return" a million rows out of 2 million...

    ==============================================================================

    Testing lookup for non-0 Ints...

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

    November 28, 2007 at 11:51 am

    #755073

  • RE: SQL Server Express is eating up my memory!

    Are you using any of the sp_OA* stored procedures? Are you closing GUI (and other) connections to the data base when they are no longer needed?

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

    November 28, 2007 at 10:11 am

    #755036

  • RE: Why is this slow?

    Matt beat me to it... using a cursor for this is a sure fire way to make code run slow. Lose the cursor and do it in the setbased...

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

    November 28, 2007 at 10:07 am

    #755034

  • RE: Where can I find all the ready-to-use Microsoft T-SQLs?

    They would be in "Books Online" which is the T-SQL help that comes free with SQL Server... learn to love it...

    Lookup "Functions" after you find "Books Online"... I'm not sure...

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

    November 28, 2007 at 10:00 am

    #755031

  • RE: To NULL or not to NULL

    My real purpose here is to determine if there really is a performance advantage to not allowing nulls, as I was told, or if our lead designer is blowing smoke...

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

    November 28, 2007 at 9:56 am

    #755030

  • RE: So You're the New DBA

    majorbloodnock (11/28/2007)

    Jeff Moden (11/28/2007)

    Heh... the only Latin I know is "Non Illigitimi ie Carborondum" (very loosly translates to "Don't let the ba----ds grind you down". What does your tag...

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

    November 28, 2007 at 8:47 am

    #755013

  • RE: SCOPE_IDENTITY Puzzle

    In a trigger? It'll only work within the trigger... trigger is at a different scope... you may want to try @@IDENTITY if you're interested in the last ID 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)

    November 28, 2007 at 8:32 am

    #755009

  • RE: Cummalitive addition

    Ananth (11/27/2007)

    Jeff,

    I got the solution. ....

    Thanks.

    Thanks, Ananth... Just curious, though... did the solution you get have a "<=" anywhere in the code? If so, you may have 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)

    November 28, 2007 at 8:17 am

    #754998

  • RE: T-SQL

    That's better, Karthik...

    I would also add a couple of things to that...

    Reason 3:

    SELECT * will normally cause a table scan (even if it looks like an index scan on 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)

    November 28, 2007 at 8:06 am

    #754991

  • RE: Database Design Question

    A location is a code varchar(10) and currently consists of 6 numeric digits where the first three are always zeros.

    First, leading zeros tend to be for display and I...

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

    November 28, 2007 at 7:38 am

    #754973

  • RE: Database Design Question

    David Burrows (11/28/2007)

    What? Oh? OH? OOOOOHHHHH!!! BWAAAA-HAAAAAA.....

    Sorry Jeff...

    Did not know if you were laughing at me :crying:

    or at my question 🙁

    or was it that I actually posted one :blink:

    Oh, bugger......

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

    November 28, 2007 at 7:07 am

    #754957

  • RE: So You're the New DBA

    Heh... the only Latin I know is "Non Illigitimi ie Carborondum" (very loosly translates to "Don't let the ba----ds grind you down". What does your tag line 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)

    November 28, 2007 at 7:01 am

    #754949

  • RE: Convert from Byte to Megabyte

    Heh... speaking of "details"... once done and you go to format it, you wanna use commas or periods for the thousand separators? 😀

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

    November 28, 2007 at 6:53 am

    #754944

  • RE: Changing Career Gears

    but I am still waiting for a good friend to help me out

    Ummm.... I wouldn't wait... take the bull by the horns and get to where you want...

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

    November 28, 2007 at 12:30 am

    #754838

  • RE: Changing Career Gears

    Nicely done, Brandie. Great success story and a great motivational story. I'll throw in that whether you have the schooling or not, you can get there if 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)

    November 28, 2007 at 12:24 am

    #754837

Viewing 15 posts - 53,866 through 53,880 (of 59,072 total)