Forum Replies Created

Viewing 15 posts - 361 through 375 (of 379 total)

  • RE: Table function execution speed

    Thanks for the explanation. Apparently, recalculating the statistics did wonders. The function executes now!! :w00t:

    Still, I'm going to investigate the index issue. While SourceID is indeed on...

  • RE: Table function execution speed

    I can certainly see your concern about this:

    WHERE R.MedGroupID = ISNULL(@MedGroupID, R.MedGroupID)

    But I'm not sure what else I can do to allow the MedGroupID to be specified yet if it's...

  • RE: Table function execution speed

    The commented lines are what I used to change it from an inline UDF to a multi-line UDF. You're correct in that it did not solve the problem, so...

  • RE: Table function execution speed

    I investigated the possibility of parameter sniffing, so I changed the function from an Inline Function to a multi-line function yet the problem persists. I've attached the code for...

  • RE: Table function execution speed

    It is indeed an inline statement that contains 3 CTEs and a final query referencing the CTEs. As I mentioned, when I pull the code out to a separate...

  • RE: Using Fuzzy Lookups for Record Linkage

    Brian,

    It's an interesting approach and one that I wish I could use, however this doesn't allow me to establish conditional matching as well. Therefore, I'm attempting to do record...

  • RE: Image is Everything

    gcopeland (1/9/2009)


    I will say again for the n-th time that business and technical skills are concurrent. If you don't like this fact of business, then get yourself into academic...

  • RE: Image is Everything

    gcopeland (1/9/2009)


    GSquared (1/9/2009)


    Couple of fallacies:

    The way that Gates and Ballmer dress is considered socially appropriate for executives. It says nothing whatsoever about technical skill. You're concatenating two thoughts...

  • RE: Image is Everything

    Ron Kunce (1/9/2009)


    I've worn everthing possible in varying work environments, from formal tuxedo's, dress uniforms, suits, business casual (with or without ties), jump suits, fatigues, battle dress, dungarees, denim, underwear,...

  • RE: Image is Everything

    D Smith (1/9/2009)


    The dress code issue is one near and dear to my heart. I've successfully lobbied to get dress codes changed to more casual ones at several places...

  • RE: Image is Everything

    crussell (1/9/2009)


    There comes a point when I look at someone dressed like a slob and think he probably programs like he dresses, doesn't pay much attention to detail. It may...

  • RE: Image is Everything

    I believe that you need to dress to fit the situation. In my position, we wear casual business dress (dockers & polos) with jeans on Friday. However, regardless...

  • RE: Calculating Age

    Similar to Sergio's solution, mine breaks down an age into quarterly periods (three months), also accounting for leap year, so partial ages can be compared:

    ALTER FUNCTION [dbo].[fnCalcAge] (@DOB datetime, @CurrentDate...

  • RE: Padding function

    This is a variant of the version that I use. I've modified it to use the same arguments as the one given in the article. I liked the...

  • RE: Recursive UDF call within a CTE

    Thanks, I'll look into it. I did find that I can create a table of entries of all rule children (tests and rules) using a recursive CTE. That...

Viewing 15 posts - 361 through 375 (of 379 total)