start by changing all those "in" for "="

You need to know if the indexes are being used ( can you post the query plan )

In addition you should also check...

Example:

create table mytable

( i int,

iname varchar(200),

reverse_iname as reverse(iname))

create nonclustered index ix_mytable_reverse_iname on mytable(reverse_iname)

insert into mytable (i, iname) values ( 1, 'FORWARD' )

insert into mytable...

Why would you say that is not quite as fast as "forward search" ?

If you create an index on that computed column you can get SEEKs from "forward searching" that...

I wished I could do that too, but the load on my Dev servers is *significant* and all the client side code is full of timeouts settings

Performace given the worload is constant will be better with a single instance because of less "extra" resources required by services etc and more memory allocated to the the instance.

To...

I am not entirely sure this was "the exact" same problem I faced a while ago but I am sure I had to apply instcat.sql to the 2000 server.

A remote DBA IMO is valid only for non-confidential *and* stable environments. Most places I have seen have one or the other but never *both*. The weakest point of hiring...

not sure what happened here but this thread looks "funky"

Hopefully this helps

You need to spend some time with BOOKS ONLINE. There is a lot good of documentation there.

I believe it has to do with Tempdb. Let me see is I can find the Source where I read it.

Totally agree, not sure why would you want that but only the poster "knows" ...

If your database is subscriber you can freely detach-attach. I have used the method I posted in the past successfully.

Note that is all on the "SAME SERVER" though.

np