You can dig back thru my history as there was a similar conversation and I posted the results of several test I did.

Basically thou there are various factors.

Text type columns,...

Or to meet just your criteria you could do

Select object_name([id]) table_name, [name] index_name, indid index_id From Sysindexes

But the key of course is the fact you are using SQL standard edition. You cannot use more than 2GB under any circumstance.

The only thing I couldn't find in the references supplied by Frank is their official name. The are called Ghost records and if you ever look at the TL lo...

Which specific functionality are you referring to?

Which tables and in which DBs are you referring? Many times people resotre DB's and forget to remove the invalid users when they go forward. But I need to know...

Yeah, but the media itself did an expose on him saying he was a White House friendly reporter with no right to be there. The media wants him gone.

Primarily offered as another solution and should be tested as with any solution.

I have found many cases (and usually those were where sorting will produce invalid results or it...

The more I do these I find this to be a better method especially for large datasets. And depending on your actual future needs it could be wrapped into a...

The only thing I can find on CProbe is a network probing utility. Are you running any specialized network monitoring tools. Might be an attack of some kind but you...

They were xp's in SQL 7 see BOL xp_trace_ in the index.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx

There are many ways to write this code, you just have to try them and weigh what occurrs in the execution plans to decide if any changes such as indexes...

Try use the MAX DOP option in your query and see if that helps. Could be it is causing a parallel execution and locking that way. Also check the execution...

Also tested the same things with SQL 7 and it behaved differently with this. Case made no difference on the third or forth run afterwards. So is this specific to...