Post reply

Beginner Question about CLR

  • August 8, 2008 at 4:41 pm

    #190920

    Can one use CLR assemblies with a database that is set to 80 compatibility level? Or does it have to be set to 90?

  • August 8, 2008 at 5:47 pm

    #855584

    80 won't work. You need it @ 90 (or better).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • August 8, 2008 at 5:59 pm

    #855588

    Thank you!

  • August 9, 2008 at 11:26 am

    #855700

    Just a bit of advice to a beginner... Most of the time where someone thinks they need a CLR, Matt and I have been able to beat the pants off of the CLR solution using good ol' TSQL. The TSQL solution is very worth while looking for. ReGex replace is about the only place I've seen where a CLR is worth a salt.

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

  • August 9, 2008 at 11:52 am

    #855706

    And instead of extended stored procedures when working with stuff outside the database (if there's absolutely a need to do that from within the DB)

    Jeff, do you know if anyone's tested the speed of a CLR proc vs the built in XQuery for shredding xml documents?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 9, 2008 at 5:21 pm

    #855716

    GilaMonster (8/9/2008)

    Jeff, do you know if anyone's tested the speed of a CLR proc vs the built in XQuery for shredding xml documents?

    No, I sure don't, Gail. Sorry.

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

  • August 10, 2008 at 1:32 am

    #855734

    Thanks. I'll test it out sometime then. It's another of those grey areas where I wouldn't be surprised if CLR is faster, however I'm not going to put money on it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 17, 2008 at 6:10 pm

    #859206

    So far, the only place I've seen CLR's beat T-SQL is in the area of RegEx Replace...

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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply