Using CLR Integration in SQL Server 2005
By Bill Graziano
on 29 November 2004
| 4 Comments
| 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. Follow the link to Using CLR Integration in SQL Server 2005...