I've recently fixed a monster that was necessarily (used in a Persisted Computed Column) a Scalar Function and I started to write about it.

Don't let this hold anyone else up, though. This sounds like a very wide open topic that a whole lot of people could have fun with.

--Jeff ModenRBAR 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 When you put the right degree of spin on it, the number 318 is also a glyph that describes the nature of a DBAs job.

Thanks, Jeff. Hoping for a few pieces. We have the one you wrote on moving a scalar UDF to a CROSS APPLY, but I'd like to get more references for specific functions that might do strange things.

My sincere apologies. I'm way overdue on this and other articles (it's been several years since I put one out there). Hopefully, things will lighten up on my end and I'll be able to crank the one I was thinking of for this out soon.

--Jeff ModenRBAR 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 When you put the right degree of spin on it, the number 318 is also a glyph that describes the nature of a DBAs job.