Openquery runs on the remote server and returns the result set.  4 part names runs local and has to suck the data across the network needed for the query.  There...

You could try something like this to make it work.

CREATE TABLE #DATACONTENT(line VARCHAR(MAX))
INSERT INTO #DATACONTENT VALUES ('\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIAN_1\C842183\CARREFOUR SANTE REPRISE\160010210006\documents entrants\Courriers divers_12470290.pdf')
INSERT INTO #DATACONTENT VALUES ('\\A1-SRV-05\REPRISE-sollyaza\Allian_ged\NOVAXEL\ALLIANZ_1\CAL000010\Volvo Allianz\VAZP100027\documents entrants\001-Doc...

Try to add a query hint to eliminate the loop join and turn it into a hash or merge. Are statistics current on the tables.

Tom

I will usually connect to master, kill all connections to the database in step 1 and then start my restore in step 2.

I've never been blocked when I've...

It looked like your plan timed out on generation. So it's just choosing whatever its on and running it. This is probably happening everytime the query is running and...

It looks like it's using the clustered index almost exclusively for all data access. I don't know if that's by design or if you thought it would use the...

You can try looking at the query plan to see if it doing tablescans during the procedure, and index appropriately. I would definitely read the link about parameter sniffing....

I'm wondering if someone didn't corrupt the file(xls) and change the column types. Have you tried creating a new xls template for importing. Is everyone having problems with...

I forgot to ask, what datatypes are in the table being inserted into.

Tom

How many indexes are on the file. I would try dropping the indexes from the file and retry. Is this a new process? I would also, if...

The first thing you need to do is to truncate the t-log. backup log <db> with truncate_only.

Then issue the dbcc shrinkfile (filename,size)

If your going to keep this in simple...

Is there a clustered key on this table. If there is then the dbcc dbreindex will free the space. If not, than nothing you do will re-org this...

You could try to create another column that reverses the phone number, index that and then reverse the input of the search and search based on the new column in...

If you run this as a scheduled job, you should be able to use a job log and the print statements should write out to that. It is on...

Can you try setting the compatibility flag back to 8.0 and see if the queries performance increase while you research the problem. I have read that instead of a...