Sean Lange (4/13/2012)

---

Here is how all of the threads that you have started sound.

There were two crocodiles flying. One to the south but another one was blue.

Question: How...

1. Create a table

2. Create an unique constraint

3. Check what is created (sp_help)

4. Drop unique constraint

5. Check what is left (again sp_help)

You will find the answer and prove it...

That is showing what really takes the time! It's getting rid of large BLOBs.

I'm afraid, you can not do much without redesign...

Try to update the image columns to null. Does it take same as long as delete?

Does not SELECT puts a Shared Lock on a table?

I agree that placing the lock itself doesn't take...

Just to add:

There is another locking hint: TABLOCKX - it will put an exclusive lock on the table, so it will not be available for selects from another transactions...

In...

Absolutely, agree. In OLTP system will be hard to find justifications for using this hint.

But this hint does exist and there...

...

It's entirely possible someone with better C#/VB.NET skill than mine can make a CLR function that's faster, but the options I found online for that were all much, much...

"FOR XML PATH ('')" T-SQL relatively new feature is used to return the results in XML form.

It does not need XML, it generates it!

Try to run this:

select d.Origin

from (

...

use WHERE clause:

WHERE [value] IS NOT NULL

Could be anything from situation where joining tables have different collation for the columns they are joined on, to using temp tables in the proc and having different default collation...

I'm sure CLR will beat the use of Number table on large datasets where...

You should provide ddl and some test data to explain your problem in more consumable way (link at the bottom of my signature will help you).

I'm not sure if that...

If you need the best possible performance - write CLR function (with defining static Regex with RegexOptions.Compiled option)

Ping if you need help with it.

Is it 4th Jan 2012 or...