Phil Parkin (12/26/2015)
Solomon Rutzky (12/26/2015)
Eric M Russell (12/23/2015)
The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.
Just out of curiosity, what exactly is this opinion based on?
I suspect it's because Eric is thinking that any 'standard' CLR processing should occur on data before it gets into the DW.
It's considered best practice, at least according to the widely adopted Kimbal methodology, that data transformation or complex joins occur either upfront during ETL stage, or downstream in the presentation layer. I can perhaps understand occasional use of custom SQL aggregates for specialzed reporting, but if you're doing stuff like parsing multivalued text or xml columns, then that suggests the DW hasnt been dimensionally modeled in proper star schema (or 3NF) form.
But that's speaking generally and why I asked earlier for details on what the intended usage of CLR is for. I mean, if I were assembling a team to develop a DW, I wouldn't look for folks experienced in CLR. It's essentially a niche technology in the context of data warehousing.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho