As it is well known that MS SqlServer 2005 has CLR integration feature to it. Now what campe up straight to my mind was when to use what , i.e when to use T-SQL and when to use CLR compaitble sp.I got the following thumb rule from a book (Introducing MS SQlServer 2005 for Developers), I'm just specifying them.
- If the code primarily accesses or modifies data , it should be written in T-SQL . CLR code can never match the DML feature of normal T-SQL.
- If the code mainly contains processor intensive operations , the code should be in .NET.
- If the developer intentionally wants to leverage the capabilities of the .NET Framework.