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 ...

It was pretty easy to deploy.” Holt also said SQL Server 2005 ran 20 percent faster than SQL Server 2000 in his tests. “The CLR is a good thing to add to SQL Server.

After confirming with the SQL Server DBA that a CLR function would be permitted on the production SQL Server, I wrote the function that appears in Listing 1. You'll notice it uses the Microsoft.Net ...

After confirming with the SQL Server DBA that a CLR function would be permitted on the production SQL Server, I wrote the function that appears in Listing 1. You'll notice it uses the Microsoft.Net ...

I have a SQL 2005 CLR procedure that builds dynamic (parameterized) SQL. I basically have a main statement, and a few different subqueries that get "plugged into" the main statement with string ...

SQL Server 2005 will integrate with the CLR, so you can deploy C# or VB.NET code within the SQL Server process. In this first of a two-part series, Shawn Wildermuth explains what's involved, and ...

SQL Server 2005 alters this calculus. It drops the .NET CLR into the SQL Server RDBMS itself, placing it on equal footing with T-SQL. The ramifications of this move are far-reaching, but the big ...