Browse by Tags

• Cursor vs Set
• Performance
• T-SQL
• UDF

• 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: CLR, T-SQL, UDF

• Poor men see sharp - more cursor optimization

  After making my post on cursor optimization I received some comments that triggered me to do some further investigation. Adam Machanic wrote in my blog’s comments that using SQLCLR to loop over a SqlDataReader would be much faster than any T-SQL based Read More... Posted Wednesday, November 28, 2007 12:47 AM by Hugo Kornelis | 6 Comments Filed under: CLR, Cursor vs Set, Performance