Forum Replies Created

Viewing 15 posts - 46,006 through 46,020 (of 59,095 total)

  • RE: highest unused ID

    Lynn Pettis (1/10/2009)

    GilaMonster (1/10/2009)

    Lynn Pettis (1/10/2009)

    I need to get it to the Dean of Electrical Engineering and Computer Science at Colorado Tech here in Colorado Springs. I am trying...

    --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 10, 2009 at 3:27 pm

    #924908

  • RE: SQL Server 2000 problem

    Maxim Picard (1/10/2009)

    There are a few others on this site and on the web. Use 'sp_oa%' as your search pattern since we are looking for sp_OACreate, etc.

    Oh, be careful... ...

    --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 10, 2009 at 8:48 am

    #924829

  • RE: highest unused ID

    Lynn, your home system absolutely smokes on this code... what does your home system consist of... I'm thinking that brand names and model numbers would also weigh in heavily here...

    --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 10, 2009 at 8:42 am

    #924828

  • RE: highest unused ID

    The 14 million logical reads for Itzik's code is pretty much what I'd expect out of the triangular join he built into his code. Why that dropped to 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)

    January 10, 2009 at 8:38 am

    #924827

  • RE: highest unused ID

    Wow... I'm thinking the dev box has a major problem.

    --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 9, 2009 at 11:46 pm

    #924786

  • RE: clustered index hell

    Although there is much good to be said about having a clustered index, if the only PK that's available is a GUID, my recommendation would be to just forget about...

    --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 9, 2009 at 10:32 pm

    #924781

  • RE: SQL CLR - Memory Issue

    It sounds to me as if someone built in a memory leak in the CLR.

    --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 9, 2009 at 10:22 pm

    #924780

  • RE: SQL Server 2000 problem

    Search the sysComments table(s) for any occurance of sp_OA. But, now that you've told us more, I don't believe that's the problem... 2GB of RAM is woefully inadequate 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)

    January 9, 2009 at 9:53 pm

    #924769

  • RE: Cursors Be Gone!

    jacroberts (1/9/2009)

    Jeff Moden (1/9/2009)

    Remember... if you're gonna practice the piano, no sense in intentionally hitting the wrong keys. 😀

    Unless you are one of these:

    http://www.youtube.com/watch?v=9nNGlaiVypU

    http://www.youtube.com/watch?v=XooTrS440Us

    LMAO!!! Oh My! That second...

    --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 9, 2009 at 9:50 pm

    #924766

  • RE: Are the posted questions getting worse?

    Matt Miller (1/9/2009)

    GilaMonster (1/9/2009)

    DavidB (1/9/2009)

    Maybe if you just post the link to the article about how to effectively post the OP will eventually get it. Maybe a bit like Tennis...

    --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 9, 2009 at 9:42 pm

    #924764

  • RE: highest unused ID

    Grant Fritchey (1/9/2009)

    There's a whole section on identifying gaps in Itzik Ben-Gan's book T-SQL Querying. Here's a way to list all the gaps, their start points and stop points:

    SELECT cur+1...

    --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 9, 2009 at 9:07 pm

    #924756

  • RE: highest unused ID

    foxjazz (1/9/2009)

    I realize you guys aren't mind readers, maybe I should restate the requirements to say lowest possible positive unused value.

    I found that I already had an identity 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)

    January 9, 2009 at 8:52 pm

    #924753

  • RE: Inserting a value in an ordered string

    Ok... that was fun... here's a function to do what you want. The function will make it easy and consistent on folks to use and I tried to build...

    --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 9, 2009 at 7:40 pm

    #924740

  • RE: Inserting a value in an ordered string

    Thanks for taking the time to explain. Even though it's for a necessarily RBAR action for a GUI and there's probably no need to handle the proverbial "millions of...

    --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 9, 2009 at 5:06 pm

    #924705

  • RE: SQL Server 2000 problem

    That's a very good question and you're absolutely correct... sp_OA had some pretty nasty memory leaks. I don't actually use sp_OA for that and other reasons, so I've...

    --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 9, 2009 at 4:50 pm

    #924700

Viewing 15 posts - 46,006 through 46,020 (of 59,095 total)