Dave Sussman - Database Geek of the Week!
Dave Sussman is an author, trainer, and ASP Insider. He has most recently worked on a book covering ADO.NET and Sustem.Xml in .NET 2.0. From the interview:
Doug: What do you think about using VB.NET or C# for stored procedures in SQL Server 2005?
Dave: I think it’s an exciting aspect of SQL Server 2005, but it comes with a warning. I’ve done talks on the SQL CLR, and I always say, “Just because you can, doesn’t mean you should.”
There has not been enough guidance on when it’s appropriate to use managed code for stored procedures. For example, T-SQL is designed for set-based work, so if you are doing simple set work, such as returning a rowset, T-SQL will be faster than managed code. If you have a stored procedure with SQL cursors, however, it’s a good candidate for managed code. The same goes if you have a stored procedure with complex business rules. I think where managed code will have more use is in functions and aggregates, which was always limited to the supplied ones.
Read the entire interview here.