Yes parameter sniffing seems to be the case here. Look at this article although it does not direcly concern with parameter sniffing. http://www.sommarskog.se/dyn-search-2005.html

I think what a decoy variable does...

Hi

Is the value being reverted back inside the procedure or from some other procedure.

check this out if it helps

http://searchexchange.techtarget.com/news/article/0,289142,sid43_gci1190351,00.html

Do you mean to say that report sql is being repeatedly executed (maybe from diff connections) and you want to find out when this whole thing started ?

Hi

If possible run a trace and check which all procedures are used. You need to run the trace for a time period where you are sure that all the procs...

Hi

If you intend to use batch deletes use TOP instead of SET Rowcount. Check SET Rowcount in BOL for more details on this.

Did you check for any locking issues?...

Hi

If you intend to use batch deletes use TOP instead of SET Rowcount. Check SET Rowcount in BOL for more details on this.

Did you check for any locking issues?...

Vishal

First thing - Do you have proper backups?

check this article http://www.sqlservercentral.com/articles/65804/

Adi

Nobody has restored the database. I checked the restorehistory table in msdb just to confirm it.

How come only the 2:00 am backup is not being taken where as the next...

Thanks Steve and sorry for the delayed reply. I was very busy.:(

Hi

OOps i selected the Report Post option instead of Qoute and sent the mail... my apologies.

I just wanted to know the status of the option to add forum questions to...

Transactions are used for maintaing data integrity. Lets says that you...

Hi

If you are using a Stored procedure use transactions.

Since it wont be empty or null Char(1) is the right answer to this question.

I wonder how most of the people got the right answer. 55% when i checked.