Here is the parameter plan.

Yes, the parameter is coming in as comma delimited.

Is there any way to determine what the problem is?

How do I find out if it is parameter sniffing?

I also used table variables to store large amount of data, would it be the problem.

How do I post the execution plan?

1

I have auto create stat on and auto update stat on the database.

I used varchar(max) because the parameter may exceed 8000 bytes.

I re-compiled the procedure so I don't have the...

I want to return all columnB.

It is because when the application wants to get all data for columnB.

But all three columns are used to make a unique id.

Yes it is the cluster key.

The bigint actually is a time field (millisecond) calculating from 1970/01/01.

The where clause of the main query is

COlumna = ? and columnC >=...

If I use data mirroring, would it be better?

I am using replication.

I mean I am not asking my boss to say thanks to me everyday!!

I am not asking my boss (who happens to be the CIO) to say thanks to me everyday.

He is the CIO but he does not even know the difference between...

Trey staker and brazumich - only you two understand job satifaction does not come from money.

My boss asked me one time to write a .NET web program and I told...

The startup cannot offer me stock option at this point.

I want to change job just becasue I am dragging myself to work everyday.

The decrease in salary will not impact my...

Citibank outsourced their IT department to India. Poor coding and poor testing results in hacking.

They deserve what they get.

My advise is not to do any business with Citibank.

I know life is short and fragile. My friend Tony went jogging last Sat, came home and collapsed and died with massive heart attack. He was only 55 years old,...