I am assuming there is not an index on the table in the tempdb db or on the table variable.  One thing I have noticed is that table variables and temp...

The other server could be using a different plan.  We'd really have to see the execution plans to get anymore information.  You can still do table scans and have it...

It sounds to me like maybe the query/sp is using the wrong execution plan.  Is it a single sp that is always as the basis of the problem.  I generally...

Just for future reference.  You could also have put a delete trigger on the table and written out the deleted data and the time it was deleted.  That helps in...

When considering fill factor, it is more that whether there are a lot of inserts or not.  It depends on the key of the clustered index.  If you have an...

How are the tables linked in access?  I know I've run into problems with tables and ms access locking schemes.  Dynaset, read-only, etc. (can't remember them all). I would look at...

I am assuming that this is a table/s in the current db.  You could also create views of the same name as the table which point to table/s in another...

Are these two machines the same hardware? Nic cards the same speed?  Have you terminaled in and ran the query local to see if speed is the same?  Do other indexes...

Are there any other indexes on the prod box.  Is it the same class/type machine.  How fragmented is the actual database files.  When you do a recovery everything is laid out...

What is the query time.  Do some tests.  Set your fill factor to something super low. 20%.  Execute your query. Then set it back to 90.  You'll notice a time...

I just did it and it worked fine for me.  You have to export each group individually under the Registered Servers X key.  Try it I think you'll find it...

I haven't tested this, but a quick look through the registry got me to this key:

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]

You can try exporting from your old machine and...

It can't be done with the restore database command.  Oney way to do something like that would be to create the multiple file db and then bulk load/dts all of...

update tablexxx

set col1 = col2

Tom

Do you have any maintenance plans running index builds or consistency checkers?  Any other maintenance that could be happening when this is going on.  One last thing is to look...