This post originated from an RSS feed registered with .NET Buzz by Randy Holloway. Original Post: T-SQL versus CLR performance Feed Title: Randy Holloway's Weblog Feed URL: /msdnerror.htm?aspxerrorpath=/rholloway/rss.aspx Feed Description: Commentary on Yukon, the CLR, and related technologies interspersed with personal opinion. Latest .NET Buzz Posts Latest .NET Buzz Posts by Randy Holloway Latest Posts From Randy Holloway's Weblog

When I teach Yukon, the students quite often ask when to use stored procedures written in T-SQL vs. procedures written using any of the CLR languages. My answer is along the lines; if your procedure is purely data access use T-SQL, if the procedure is doing lots of computational work use the CLR.

During the last gig (in Korea), the question was raised again, and instead of just give the standard answer I decided to "croft up" some code to really see the difference.

[managed data]