Jeff Moden (2/21/2014)
eric.notheisen (2/21/2014)
I worked on a project for Wells Fargo a few years ago. We had a database developer who used CLR procedures for 60 percent of his stored procs. We found the performance hit to be minimal and [font="Arial Black"]the flexibility to be superior.[/font] In my current work I have used CLR procedures several times when I needed to recursively look at or process .dataFlexible how and superior to what?
When it comes to databases, scalability, extensibility, and maintainability are good, but flexibility can have some negative connotations.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho