Sometimes yes, just make sure you give it a different name and use 'with move'...

i usually handle it the lazy way

You can probably get hold of dll to use as an extended proc to compress the data into a blob if you wanted.

how about change the and to an or?

Have you got enough disk space...?

You could (Should) simply declare (depending upon the size of the result set) a variable table or a #TEMP table. Smaller sets go with a Variable table no question. Easier...

unless its part of a transaction and the isolation level is appropriate or an updatelock or something has been issued.

Just reaching here, but sometimes you might see this depending on the data distribution. 

In this example plan 1001000046 may have a different data distribution than 1001000068 - possibly producing...

You mean here: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx ?

Where it states almost the exact opposite, or am I missing your point?

When analyzing the output from DBCC SHOWCONTIG, consider the following:

Try bcp'ing the data out to an intermediary textfile then bulkinsert it back in.

Do it right and the performance gains can be massive.

Hi, had a similar issue last year.

The compat collations are often for upgrades from previous versions/access.

The only way around it I found (don't try to get a 'similar' one...

There is a chance you may be able to recover this by updating the statistics on the relevant tables.  I have had experiences similar to this, where the growth rate...

oltp it is - also quite narrow.  On the positive side there are several data streams into it that can be turned off if required - gives us a nice...

Personally I suggest in the short term you just pop it in the one table, if it becomes difficult later you can simply add constraints to the underlying table and...

You could set up a scheduled ftp task?

Or you could look at log shipping, get the db off once then just apply the small transaction logs?