140 reputation
3
bio website
location New York, United States
age 33
visits member for 2 years, 4 months
seen Aug 1 at 18:01

Professional Programmer in VBA, C#, WPF, C++, ASP, and SQL.


Jun
13
awarded  Supporter
Jun
13
accepted Performance of Inline-TVF vs. Views
Aug
15
comment User defined function performance disadvantages
got it. thanks @mr.brownstone
Aug
15
comment User defined function performance disadvantages
the UDFs I'm wondering about are actually table valued functions, not scalar functions. I believe the 1-row-at-a-time problem with UDFs only occurs when you are using scalar functions.
Aug
15
comment Performance of Inline-TVF vs. Views
@MarkStorey-Smith yes, the reason is as you say, code-monkey vs data-monkey approach.
Aug
14
comment Performance of Inline-TVF vs. Views
@mrdenny Is there no way to predict how the optimizer is going to treat each type of query? Surely there are some rules it follows.
Aug
14
comment Performance of Inline-TVF vs. Views
@Andomar my understanding is multi-statement TVFs are run like a black-box, the engine doesn't know what's in it and can't optimize the query. Do you have any articles you can reference that say views and inline TVFs are equivalent?
Aug
14
comment Performance of Inline-TVF vs. Views
that's what i thought, but i was told that the TVF acts like parenthesis would in algebra -- it forces the DB engine to complete that query first before optimizing. Using views, i'm told, allows the optimizer to optimize the whole query as a unit.
Aug
14
awarded  Scholar
Aug
14
accepted Should I use table hints with a process-keyed table?
Aug
14
comment User defined function performance disadvantages
Yes, I'm trying to broaden the audience to get a different perspective. another user from my other question suggested i post here.
Aug
14
asked Performance of Inline-TVF vs. Views
Aug
14
asked User defined function performance disadvantages
Apr
19
awarded  Student
Apr
19
asked Should I use table hints with a process-keyed table?