Stairway to SQLCLR Level 1: What is SQLCLR?

Question

Post reply

Stairway to SQLCLR Level 1: What is SQLCLR?

Solomon Rutzky

SSCoach

Points: 16430
More actions
January 8, 2014 at 4:24 am

#281771

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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR

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

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

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 1

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.

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)

Alan Burstein SSC Guru Points: 61141 More actions · Answer 2

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!

"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

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 3

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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

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.

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)

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 5

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 Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR