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

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

So long as its deterministic - yes.

>
> Can you change a database concurrency model via CLR ?
>

Yes

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

You have User Definied Types which are serialised, so you can create whatever objects you want as a UDT in CLR, a good example would be a temporal object.

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

The last two brings to think you don't actually know what CLR and .NET actually are, you can CLR in a database that is clustered - not a problem.

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


"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message 
news:43EE6AF6.9060700_at_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.

>

>