Viewing 2 posts - 1 through 2 (of 2 total)
It looks like it has been due to 'Parameter Sniffing' technique used by the query optimizer.
You may find useful information regaring this issue from the following link.
http://blogs.msdn.com/khen1234/archive/2005/06/02/424228.aspx
September 8, 2005 at 5:07 am
#588354
In a SQL Server 2000 Log Shipping setup, if a NDF/LDF file is added to the Primary database participating in Log Shipping, the same drive...
September 5, 2005 at 10:26 pm
#587657