Forum Replies Created

Viewing 15 posts - 46,021 through 46,035 (of 59,101 total)

  • 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

  • RE: Where 1 = 1

    Heh... But, it won't solve a bloody thing and it won't prevent the problems that you describe... people will simply get into the habit of adding WHERE 1=1 and still...

    --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:41 pm

    #924697

  • RE: Inserting a value in an ordered string

    Ah... that's a slightly different story. Am I to assume that you want the digit to be inserted in the correct ascending numerical order... in other words, the 7...

    --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:05 pm

    #924677

  • RE: Cursors Be Gone!

    Matt Whitfield (1/9/2009)

    So, collectively we fixed a logic funny for you, and made it quicker to boot.

    Go team! 😛

    "Go Team" is right!

    If I may, please consider what...

    --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 3:59 pm

    #924671

  • RE: Inserting a value in an ordered string

    Heh...bwa-heh... BWAAA-HAAA!!! Hey, Sergei... STUFF it will ya? :P:D:)

    Oh dear... couldn't resist the pun. Seriously, though... that's the answer... see here...

    DECLARE @SomeExistingString VARCHAR(100),

    ...

    --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 3:07 pm

    #924641

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/9/2009)

    Grant Fritchey (1/9/2009)

    Jack Corbett (1/9/2009)

    Steve Jones - Editor (1/9/2009)

    I'm with Grant, heat, heat, heat.

    I like skiing, but other than that, I'd like warm weather all the time.

    Denver doesn't...

    --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 2:46 pm

    #924620

  • RE: Very new Newbie Needs Help with simple query

    Yeah... that's one thing that Oracle does do better... some of the implicit conversions. If you look in Books Online (comes with SQL Server as the help system)...

    --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 2:41 pm

    #924613

  • RE: Virtualization forum section

    It's there... just doesn't look that way because (sorry) ... it's virtual. 😛

    Actually, it sounds like a good idea. The boys in ops just virtualized all of our...

    --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 2:31 pm

    #924606

  • RE: Look at the size of my BCHR

    BWAA-HAAA!!! "I'll show you mine if you show me yours."

    I've never looked, but I'm just betting that the BCHR is nearly 100% for cursors... 😉

    --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 2:23 pm

    #924600

  • RE: Where 1 = 1

    GSquared (1/9/2009)

    I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something like "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)

    January 9, 2009 at 2:19 pm

    #924596

Viewing 15 posts - 46,021 through 46,035 (of 59,101 total)