Forum Replies Created

Viewing 15 posts - 50,116 through 50,130 (of 59,091 total)

  • RE: BETWEEN

    ... and that's why I hate multiple-guess questions... gimme a good solid essay question or lemme write some code, instead!

    That was a fun conversation to watch... thanks, Gents. 🙂

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

    June 11, 2008 at 8:58 pm

    #827625

  • RE: CLR Table-valued function

    Heh... and Marketing.

    Nice explanation, Barry!

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

    June 11, 2008 at 11:53 am

    #827444

  • RE: CLR Table-valued function

    rbarryyoung (6/11/2008)

    That sounds like a challenge...!

    Seriously though, "useful" and "appropiate" were not part of your specs. 🙂 They're a lot harder to fulfill. (Though as Lynn says,...

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

    June 11, 2008 at 11:48 am

    #827439

  • RE: CLR Table-valued function

    Matt Miller (6/11/2008)

    Jeff Moden (6/11/2008)

    rbarryyoung (6/11/2008)

    Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.

    Heh... ok, I gotta ask... has anyone actually ever...

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

    June 11, 2008 at 11:43 am

    #827436

  • RE: CLR Table-valued function

    rbarryyoung (6/11/2008)

    Well, if we're looking for examples, a Fourier Transform would proabably be a good candidate for CLR.

    Heh... ok, I gotta ask... has anyone actually ever done a Fourier Transform...

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

    June 11, 2008 at 9:55 am

    #827366

  • RE: CLR Table-valued function

    Thanks for the feedback. Just curious, what type of "math functions" are you talking 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)

    June 11, 2008 at 7:23 am

    #827228

  • RE: BETWEEN

    VALEK (6/10/2008)

    ps: I answered the original question correctly FYI, but I just wasnot happy with ... the tools used to generate a testbed. QA engineers and Professional Software Testers will...

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

    June 11, 2008 at 5:35 am

    #827166

  • RE: CLR Table-valued function

    nenad.prekupec (6/11/2008)

    The reason of opinion that CLR is slower then T-SQl is just because people didn't get familiar with CLR and doing ridicules performance test to show CLR is slow.....

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

    June 11, 2008 at 5:14 am

    #827154

  • RE: My Own Custom Table Partitioning

    ammon (6/10/2008)

    So, regarding one of my questions, how well does a table perform with over 2 billion rows?

    Ya got me... I've worked with tables as large as 200 million rows,...

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

    June 10, 2008 at 10:17 pm

    #827056

  • RE: Error Creating format file for bcp

    For those that want to follow along in English...

    http://msdn.microsoft.com/en-us/library/ms178129.aspx

    There are many problems with the command that you have submitted. First, do you have a table already available called MyTestFormatFiles...

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

    June 10, 2008 at 9:03 pm

    #827039

  • RE: My Own Custom Table Partitioning

    I agree with Paul's assessment... it's a good thing to plan on that type of scalability, always... but I see no mention of "clustered" servers or the other things 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)

    June 10, 2008 at 7:23 pm

    #827031

  • RE: BETWEEN

    Heh... No matter what, I'm happy I don't have to earn a living by taking Matt's tests 😛 They are thought provoking to say the least...

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

    June 10, 2008 at 7:08 pm

    #827024

  • RE: My Own Custom Table Partitioning

    Then, BigInt should do the trick.

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

    June 10, 2008 at 7:25 am

    #826627

  • RE: My Own Custom Table Partitioning

    Just curious... Max size for INT is over 2 billion... that should handle your 10 million rows quite nicely for 214 tables. Why would you need unique numbers 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)

    June 10, 2008 at 7:06 am

    #826601

  • RE: The Bulldogs

    Steve,

    The link to "IT Project Failure" is broken.

    On the subject of IT Project Failure... how often is it that IT is the one that "designs" a project? Normally, it's...

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

    June 10, 2008 at 4:58 am

    #826530

Viewing 15 posts - 50,116 through 50,130 (of 59,091 total)