I now have 8 of them spread over the log and data drives at the moment.

They were all on the raid 1 OS before, with this configuration I also saw...

OK run on each database

1. for the SQL 2005

2. for SQL 2008 r2

Artoo22 to answer you, the database have the same indexes. Too prove this to myself today (at a loss with this one), I again backed the database up only 3...

There should be no contention at all this database server has nothing I mean nothing running on it. The only database is the one that I am providing the details...

Sure here we go

2 files

1. 2005 - fast.sqlplan - this the old 2005 server

2. 2008r2 - Slow.sqlplan - This is the new server, now with TempDB the auto...

Both are set to false or 0. My SQL 2005 has both set to true. Though these settings were also tried and tested before changing them (changing them was...

Thanks Jeff,

I hope so, this one is causing me a few sleepless nights!

Thanks Jeff,

I have zipped both plans up.

1. Long running Plan.sqlplan - this is the one that is taking longer SQL2008R2 (problematic)

2. Quick plan.sqlplan - This is the 2005 box that...

Sorry for the late response guys

Yes I have repeated the execution of the query more than 10+ times with the same % on the new database server.

in terms of...

thanks scott, I am using SQL 05

so I am using

sp_msforeachdb 'use [?]exec sys.fulltext_catalogs'

however I am getting

The request for procedure 'fulltext_catalogs' failed because 'fulltext_catalogs' is a view object.

If I...