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

Tony Rogerson wrote:
> 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).
>

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

Or in my opinion will be the death of SQL Server ... whichever comes first.

C and C++ developer proved they didn't belong in the database.

Java developers have proven they don't belong in the database.

.NET has now given people who couldn't tell the diference between cardinality and rosary beads the ability to do what previously was only done by people who knew SQL ... meaning something about databases.

I expect within a few years to see a staggering consulting business develop fixing the mountains of unscalable poorly performing messes made by people who wouldn't recognize a data integrity constraint if it bit them on the nose.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)