Return to Using CLR Integration in SQL Server 2005
Using CLR Integration in SQL Server 2005
Written by Bill Graziano on 29 November 2004
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.