Browse by Tags

• CLR
• Conference
• People
• Performance
• Personal

• SQLRally Nordic 2012 – session material

  As some of you might know, I have been to SQLRally Nordic 2012 in Copenhagen earlier this week. I was able to attend many interesting sessions, I had a great time catching up with old friends and meeting new people, and I was allowed to present a session Read More... Posted Friday, October 05, 2012 7:49 PM by Hugo Kornelis | 0 Comments Filed under: T-SQL, Performance, Conference, People, UDF Attachment(s): User-defined functions.zip

• T-SQL User-Defined Functions: the good, the bad, and the ugly (part 4)

  Scalar user-defined functions are bad for performance. I already showed that for T-SQL scalar user-defined functions without and with data access, and for most CLR scalar user-defined functions without data access , and in this blog post I will show that Read More... Posted Saturday, August 25, 2012 12:07 AM by Hugo Kornelis | 9 Comments Filed under: T-SQL, CLR, UDF

• T-SQL User-Defined Functions: the good, the bad, and the ugly (part 3)

  I showed why T-SQL scalar user-defined functions are bad for performance in two previous posts. In this post, I will show that CLR scalar user-defined functions are bad as well (though not always quite as bad as T-SQL scalar user-defined functions). I Read More... Posted Friday, June 29, 2012 9:44 PM by Hugo Kornelis | 6 Comments Filed under: T-SQL, Performance, UDF

• T-SQL User-Defined Functions: the good, the bad, and the ugly (part 2)

  In a previous blog post , I demonstrated just how much you can hurt your performance by encapsulating expressions and computations in a user-defined function (UDF). I focused on scalar functions that didn’t include any data access. In this post, I will Read More... Posted Saturday, May 26, 2012 5:56 PM by Hugo Kornelis | 1 Comments Filed under: T-SQL, UDF

• T-SQL User-Defined Functions: the good, the bad, and the ugly (part 1)

  So you thought that encapsulating code in user-defined functions for easy reuse is a good idea? Think again! SQL Server supports three types of user-defined functions. Only one of them qualifies as good. The other two – well, the title says it all, doesn’t Read More... Posted Sunday, May 20, 2012 5:08 PM by Hugo Kornelis | 23 Comments Filed under: T-SQL, Personal, UDF