gocheski (1/5/2016)

---

Good Article, Just I was wondering about scalar function, the difference between having read from table inside and don't. In the first example where you're using dbo.fn_SumRangeOfNumbers() I guess...

winkl (1/4/2016)

---

Thanks for the article, Mickey.

Have you tested your scalar UDF using schemabinding? We're testing that now to see if we can bring some of the cost...

lucien.jacquet (1/4/2016)My point is not to contradict your assertion that scalar functions "can be" expensive, but to suggest that your example is a worst-case scenario. Is it possible that your...

A few of you commented on the fact I stated the wrong edition of SQL that User Defined Scalar functions were introduced in. I apologize. I will have it corrected....

Hi Eirikur,

Thank you for the SQL Example. I agree whole heartedly with you. This article is one of three articles. The first, focusing on User Defined Scalar Functions...

Hi Everyone,

Thank you for all the comments and questions. I'm swamped at work today, so I will reply this evening when I get home (California time).

Cheers!

Mickey

This post has great timing. Just yesterday I sent my manager an analysis of a log table that was created a year ago that is massive. I'm hoping I can...

The job of the Foreign Key...

The applications that I've seen that are missing foreign keys have (at least these) three issues.

1. Bad data in fields that should be clean.

2. Extra deployments of the...

I am such a HUGE problem solver. I still need to learn what not to fix. It's frustrating for me to see bad design, and bad practices.

Thank you for...

Steve, I think this is a great discussion topic and it has always evoked a lot of passion for people, usually based on their own background.

I've worked with people...

stephen.kratowicz (6/23/2015)

---

Agreed, sequelgarrett. It seems as though with that point, the author is assuming you will use

SELECT *

FROM [viewWithTooManyColumns]

...but if you instead use

SELECT SomeColumnIReallyNeed, SomeOtherColumnIReallyNeed

FROM [viewWithTooManyColumns]

...then the...

sequelgarrett (6/23/2015)

---

Do the number of columns in the definition of the view really matter from a performance perspective? I thought the columns returned from a view only matter when the...

ron.lee (6/23/2015)

---

Good article.

I seem to get dragged into the same argument over time about whether to use select table.* to form a generic query reusable across reports or to...

Thanks Jeff. I plan on it. 🙂

Mickey