Stairway to SQLCLR Level 1: What is SQLCLR?

  • Solomon Rutzky

    SSCoach

    Points: 15964

    Comments posted to this topic are about the item Stairway to SQLCLR Level 1: What is SQLCLR?

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • Jeff Moden

    SSC Guru

    Points: 994279

    VERY nice, Solomon. Great job!

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Alan Burstein

    SSC Guru

    Points: 61026

    Great Article Solomon. Very easy read and informative. I have been looking forward to a SSC Stairway on CLRs for a long time and look forward to the rest of the series. I like how you included a "What CLR is and is not" section. I also like the additional resources section -- very extensive. Great work sir!

    -- Alan Burstein


    Helpful links:Best practices for getting help on SQLServerCentral -- Jeff ModenHow to Post Performance Problems -- Gail ShawNasty fast set-based string manipulation functions:For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)To split strings based on patterns try PatternSplitCMNeed to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8KI 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

  • Solomon Rutzky

    SSCoach

    Points: 15964

    Thank you both very much for the kind words :-). I am glad that you both enjoyed the article and found it informative.

    Just FYI, there is possibly a little glitch in the publishing of the article such that this forum (and its comments) might disappear. If that happens, and if you have time, it would be appreciated if you re-posted your comments ;-).

    Thanks again and take care,

    Solomon...

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

  • Jeff Moden

    SSC Guru

    Points: 994279

    Solomon Rutzky (1/8/2014)


    Just FYI, there is possibly a little glitch in the publishing of the article such that this forum (and its comments) might disappear. If that happens, and if you have time, it would be appreciated if you re-posted your comments ;-).

    No problem. Please submit your request in writing (so I don't forget)... on a $20 bill carefully wrapped around a fresh #9 Jimmy John's Italian sandwich with extra Italian dressing, hold the mayo and the onions. 😉

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Solomon Rutzky

    SSCoach

    Points: 15964

    As anticipated, the publication issue has been fixed but that resulted in this forum being "lost" (along with ratings, etc), though apparently still accessible if you have the link.

    The new / "real" forum is located at:

    http://www.sqlservercentral.com/Forums/Topic1528722-403-1.aspx

    Jeff, would you like chips and a drink?

    Thanks, Solomon....

    SQL#https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
    Sql Quantum Lifthttps://SqlQuantumLift.com/ ( company )
    Sql Quantum Leaphttps://SqlQuantumLeap.com/ ( blog )
    Info sitesCollations     •     Module Signing     •     SQLCLR

Viewing 6 posts - 1 through 6 (of 6 total)

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