Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Tally OH! An Improved SQL 8K “CSV Splitter” Function RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

  • September 10, 2014 at 9:33 am

    #1744474

    Steve Jones - SSC Editor (9/10/2014)

    Jeff Moden (9/10/2014)

    Solomon Rutzky (9/9/2014)

    In the end, isn't this why Microsoft gave us CLR Integration?

    Heh... yeah... just like they gave us the ability to write extended stored procedures. 😉 I wonder when they'll deprecate and discontinue SQLCLR.

    Not likely ever. This is internally used to implement things like HierarchyID, Spatial types, etc. The CLR is an exposure of an internal system for us to use.

    MDS and DQS also rely heavily on CLR - those are not going away anytime soon.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001