Using CLR Integration in SQL Server 2005

By Bill Graziano on 29 November 2004 | Tags: SQL Server 2005 , CLR

This paper describes how database application developers and architects can take advantage of the CLR integration features in SQL Server 2005. It compares CLR-based programming with existing programming models supported in SQL Server, such as Transact-SQL and extended stored procedures, and highlights the relative strengths and weaknesses of each. It also provides a set of high-level guidelines to pick the appropriate programming alternative, and a set of examples and code samples. This is a great whitepaper on when to use the CLR vs when to use T-SQL. Lots of performance issues discussed.

Link: Using CLR Integration in SQL Server 2005