Forum Replies Created

Viewing 15 posts - 46,951 through 46,965 (of 59,064 total)

  • RE: The Numbers Table

    jacroberts (11/27/2008)

    Ok, I have recently written some code that uses an RBAR TVF to increase the efficiency and speed of a query.

    Here's my example:

    We had a table of...

    November 27, 2008 at 8:25 pm

    #904536

  • RE: Functio to get Amount in words.

    For the most part, Yes. On concatenation of such a small number of parts, not really.

    November 27, 2008 at 4:47 pm

    #904508

  • RE: Functio to get Amount in words.

    Very cool code, Chris... your' guy's efforts made me finish up what I started and it looks nothing like the original code I posted... I couldn't stand the fact that...

    November 27, 2008 at 4:37 pm

    #904506

  • RE: Functio to get Amount in words.

    Chris Morris (11/27/2008)

    Jeff Moden (11/27/2008)

    Chris Morris (11/27/2008)

    Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, in...

    November 27, 2008 at 3:04 pm

    #904497

  • RE: Functio to get Amount in words.

    Chris Morris (11/27/2008)

    Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, in about 4 seconds.

    Ummm......

    November 27, 2008 at 11:35 am

    #904446

  • RE: The Numbers Table

    Lynn Pettis (11/27/2008)

    And two, someone is going to come along and see your code in your RBAR TVF and use it somewhere else and it won't be effecient at all.

    Heh......

    November 27, 2008 at 11:10 am

    #904439

  • RE: Calculate the Running Total for the last five Transactions

    Lynn Pettis (11/26/2008)

    Good article, but let's take another approach and see what we see.

    Heh... you beat me to it, again. 😉

    November 27, 2008 at 11:02 am

    #904436

  • RE: Calculate the Running Total for the last five Transactions

    Hugo Kornelis (11/27/2008)

    What I was refering too is the lack of ROW_NUMBER() in SQL Server 2000. This means you'll either have to take your chance with IDENTITY, at the risk...

    November 27, 2008 at 11:00 am

    #904435

  • RE: can i improve performance in this query

    Peso (11/27/2008)

    The query returns 290 columns and joins 62 tables. Under these cirumstances I think 7 seconds is quite good.

    Ditto.

    November 27, 2008 at 10:30 am

    #904424

  • RE: Knowledge sharing

    Mannie, thanks for posting the article... your points are well taken and the appearance of the article is actually very timely for me. It gave me a chance to...

    November 27, 2008 at 10:27 am

    #904423

  • RE: Knowledge sharing

    David Burrows (11/27/2008)

    And Jeff makes a good point too. Not enough of you guys get credit for posting knowledge...

    Hear, hear. 🙂

    But I think we all owe thanks to folks...

    November 27, 2008 at 10:20 am

    #904418

  • RE: Knowledge sharing

    thisisfutile (11/25/2008)

    Jeff Moden (11/25/2008)

    ...

    Heh... then there's the "intelligent" ones that say things like "performance" doesn't matter and will argue for hours about it. The only reason why I continue...

    November 27, 2008 at 10:17 am

    #904416

  • RE: Knowledge sharing

    G Bryant McClellan (11/25/2008)

    Manie makes some very good points. I wish SQLServerCentral had been around in 1994 when I started working with SQL Server.

    And Jeff makes a good point too....

    November 27, 2008 at 9:49 am

    #904407

  • RE: Are the posted questions getting worse?

    Matt Miller (11/26/2008)

    ...and - we're doing it again. By virtue of this thread alone - we're HIGHLIGHTING the "ugly threads" which mean they get more facetime, and (probably) more...

    November 26, 2008 at 10:43 pm

    #904139

  • RE: random randomise randomize data query

    Yep... try getting the TOP 10 random rows from a big table that way... hell to pay for performance. Be careful how you use it for that reason.

    November 26, 2008 at 10:17 pm

    #904137

Viewing 15 posts - 46,951 through 46,965 (of 59,064 total)