its not normal that for sure.....how much memory do you have?

its possible that you do not have enough memory avail. to sql therefor its is having to use the pagefile....might...

after rereading your original post and it is starting and stopping it sounds like the mail client is set up correctly

sound like it is getting queued as well?

select * from

dbo.sysmail_mailitems

go the error log and select database mail....let us know what the error is

FYI..not so sure you will be able to use bulk insert while trying to move data from table to table as you stated earlier. this is for garbing flat files...

if you choose to use bulk insert then please refer this post from the sql cat team...they have did a little testing in this area that should be a great...

change your recovery mode to Bulked-logged before you do you insert in then turn it back after you are done.

There are many other questions.... this is going to cause...

looks like you got it....

#2 is the biggest thing....and you got that covered.

so even if miss something no biggie...since @ 2 is covered you should be good to go.

If you havent already you probably want to define your alerts 11-24 are the usual suspect you can find them on BOL

so if you run it tomorrow one can be slower then other depending on if the data is in cache.

since both SHOULD reuse the same qry plan you will not...

in order to test them both you need to go to your dev box clear the cache and memory and then run 2008, then clear out the cache and memory...

looking back at the original question you said the first time it took 33 sec?

and the sec question you say the 2008 first time it was very fast....I am little...

if you are asking why 2008 is faster then 2005. the query plan is much more efficient in 2008.

If you looked at both query plans you would probably fine...

try this

Run ALTER INDEX command with SET (ALLOW_PAGE_LOCK = ON)

In SQL 2005 the full text search engine was outside of sql server engine there for it was not able to take advantage of the sql server statistics.

The query optimizer...