Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Tue, 14 Feb 2006 17:47:42 -0000
Message-ID: <dst539$j5u$1$830fa7a5@news.demon.co.uk>

CLR :: Common Language Runtime.

In a nutshell it allows you to write code in any langauge that supports the Common Language Specificiation in .NET (there are a lot now and not just MS grown ones).

Now its integrated into SQL Server we can write stuff that T-SQL doesn't do very well like string manipulation, complex mathematics, point data types, objects etc... in a .NET language and then run them in SQL Server using the CLR environment.

It allows us to extend SQL Server infinitely using CLR - User Definied Functions, Types, Stored Procedures, Triggers etc... - its quite cool to be honest, no doubt other vendors will catch up in future versions.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message 
news:1139934478.488827.321300_at_g14g2000cwa.googlegroups.com...


> What's a CLR sorry not familiar with that terminology?

>

Received on Tue Feb 14 2006 - 11:47:42 CST