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

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Sat, 11 Feb 2006 14:53:42 -0800
Message-ID: <43EE6AF6.9060700@comcast.net>

Cross posts trimmed at request

> if I want to write a
> regurlar expression function that can be used anywhere within SQL Server I
> can write it in CLR and call it anywhere I can use a built-in system
> function.

Can you then build an index on a column using the regex, gather stats for it, and then have the optimiser consider this index in it's costing calculation ?

Can you change a database concurrency model via CLR ?

Can you have the database change the way it physicall stores data and generates incremental backups via CLR ?

Can you have a database support active/active clustering via CLR ?

Can you have a database run on Linux or any other operating system via CLR ?

Don't be so obtuse. Received on Sat Feb 11 2006 - 16:53:42 CST