One possible approach, probably the only way, is:

Create a new column with a primary key (or with unique value);

Remove the duplicate rows (not include the column with the primary key)...

If you use SQL Server Profiler, do not forget to use filter. Otherwise, you may have troubles in performance.

Thank you so much for your input. I thought tempdb would be created always with the default size, 8 MB.

They are not easy questions. Here are my inputs.

1. I think you have to create a new database. Then, export data. Otherwise, you have to merge the two file groups...

Could you described what you found in more detail?

Nice explanations.

You do not need to use the profiler. Using profiler is alway dangeous if you cannot narrow down your problems.

I would like to recommend you to create an error...

http://www.sql-server-performance.com

You will find even its structure is quite similar to this site.

An IO may not block a table. For example,

SELECT * FROM myTable WITH (NO_LOCK)

I thought the original question is for nested.

Your description is not clear enough. In order to determine which approach to use, we need to know what kind of data (partial or all) you would like to transfer.

For...

I think you can upgrade the version from standard to enterprise.

If you do install a clean enterprise version, then,

Backup all your databases;

Uninstall the standard version;

Install the enterprise...

I think you can upgrade the version from standard to enterprise.

If you do install a clean enterprise version, then,

Backup all your databases;

Uninstall the standard version;

Install the enterprise version;

Start...

You do not need to set it to single user mode.

How about master..sysprocesses table?