Can we see the while code?

Actually it's the other way around. Change the query, if there's still a timeout, then correct the timeout limit on the apllication side

Don't run the plan, just tell me what you see. What part of the plan takes the most time (in %) of the query. If you have something...

One thing you must know about sqlserver managing ram is that it'll take all you give to him for faster data access. If you have a 1 gig db...

HTH.

The short answer would have been to use the system procedure sp_renamedb 'oldname', 'newname' in the first place to do this.

Maybe it'll still work in this case but I doubt...

The real question is why do you have to reboot the server? What is the bottleneck (cpu/disk/ram).

When are you doing this importation (off hours when the site is not...

assuming that the select query works, just remove the values keyword and the parenthesis around the query (they are optional).

Which doesn't seem extremely slow. It's not fast but it's hard to judge without the rest of query and the table size...

Now can you look up the execution plan...

Change B.* to a column name that is not a text/image column, or to a constant like 1.

Please do not cross post. I already answered your question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=191642

Define big (1k, 1M, 1B rows???)

Is the where condition sarg (look up bol for this one)?

How long does it take to simply select the data from Oracle without redoing any...

Update A set A.col4 = dtMaxDates.Col4 from TableA a inner join

(Select col1, col2, col3, max(col4) as col4 from dbo.TableB group by Col1, Col2, col3) dtMaxDates

on A.col1 = dtMaxDates.col1 AND A.col2...

Here's a demo with the system tables.

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name + ',...

Or maybe there won't be enough work done on Oracle... I've often seen that sql server will import the whole table(s) and do the work locally without indexes. while...