-- For jobs that are well suited to .Net languages, should the code run inside the database engine or on a separate system in order to save resources on the database server?

Sidebar

T-SQL vs. CLR

In SQL Server 2005, developers have a choice of programming in Transact-SQL or languages supported by Microsoft's Common Language Runtime.

-- CLR: Best for code that's computation- or logic-intensive. A better option than 'extended stored procedures,' which Microsoft offered in earlier SQL Server releases for creating server-side code with logic that's difficult to write in T-SQL.