The thought of being tossed back a hundred years into the past kinda freaks me out. If I were fortunate, I'd be a musician -- wouldn't need to be famous,...

Agreed, I probably painted Celko's viewpoint with too wide a brush.

As for your mention of views, you've answered a question I was pondering: can the optimiser leverage a view much...

hallidayd,

As an initial step to breaking down the udf, specifically with the modified udf you provided, I converted the nested udfs (within the cross join) as inline udfs as...

Gee wiz, Mr Celko-- I never thought that this discussion thread would draw your attention. As much as I'd like to consider your post helpful, I'm not so sure...

Well, I decided to test out changing the tabular multistatement udf to be inline as suggested in a previous post. To my surprise (shock), converting the udf to be inline...

I'll have to check...

Awesome information!

I'll start digging into the code, as well as attempt to translate the execution plans, and see if I can configure SQL Profiler correctly to assess performance.

Thanks...

OK -- really cool.

Any issue with parameter sniffing with the modified inline udf? I'm wondering about @user-id?

Would it be helpful if the container stored proc assigned the

Hallidayd --

Hmm, very interesting - I'm intrigued... Your changes remind me of Itzik Ben-Gan's technique for making a scalar udf become an inline table-valued udf: (http://www.sqlmag.com/print/sql-server/inline-scalar-functions.aspx).

So, in the...

OK -- I'm getting a better sense of parameter sniffing performance issues.

Since people have been asking about whether the udfs are inline or multi-statement, below is the code for one...

GilaMonster - are you saying that joining to tabular udfs on large row counts can drastically...

Regarding parameter sniffing, how much of a performance impact does it have? Has anyone seen a query/report improve from hours to minutes or from a minute to a few seconds...

Wow, thanks for the quick replies --

First, as useful as sharing examples of the code can be for others to help assess the problem with query performance, I'm going to...

Thanks for the reply, Drew.

Yup, the trick is identifying the unique records (which I call "cases"). Fortunately, I developed quite a few identification rules which do a really good...

Thanks for the quick reply -- I've actually come up with a new formula that I think gets it right by merely tweaking the numerator (and agrees with your duplication...