I have attached the execution plan for the query.I am posting my query and indexes which i created as per your specification.

My query:

...

GilaMonster (3/4/2011)

---

GilaMonster (3/3/2011)

---

You need two indexes because of the or

One index on Primary, one on Secondary. You may need to make both covering, depends on the rows involved. test and...

Philip Turtle (3/3/2011)

---

If you paste the SQL into a query window in SSMS and press CTL-L you will see the estimated execution plan. SSMS may display a Missing Index suggestion...

HowardW (3/3/2011)

---

I suspect the OP is aware of the nature of the data and isn't trying to translate from Korean into English 🙂

I'd suggest reading up about collation.

To put it...

They probably are looking like junk as you are not familiar with the Korean characters used in the data.

Importing oracle data is not too tough but as you said,converting the...

It is...

david russell-253790 (11/27/2005)

---

this is, once again, the mentatity of management. they migrate to SQL Server because they have this perception that "a monkey can do it" as far as implementing...

Though I work with the administration part most of the times,I do look at the queries that hit my databases.If there is a routine task that needs to be done,then...

Roy Ernest (5/17/2010)

---

When you are pinging, is it continuous? Not even one packet dropped? What is the latency between the two servers?

I think you will need to involve the...

Roy Ernest (5/11/2010)

---

I have set up replication between where I am (Caribbean Isles) to Asia. The one thing that we had was VPN and a pretty good connectivity. We never...

Today I had a look at the Default Agent Profile properties for my merge replication.There is a parameter 'Login Timeout' which is set to 15 seconds by default.Could this be...

Roy Ernest (5/11/2010)

---

The error "Transport Level error" usually happens when the connection to the DB is disrupted. It could either be the network layer or your DB is disconnecting your...

Dave Ballantyne (5/10/2010)

---

To me this is more telling that...

Can somebody please throw some light on this(even if the exact fix is not known)

Thanks for your advice.I guess by scripting the table structures from source db,one can spend sometime and create them in the new tables.Its time consuming but acceptable given the strange...