We have a home grown transaction log process that has been working fine until just now.
we have recieved the error
Weird error:
Server: Msg 3242, Level 16, State 1, Line 2
The file on device 'LogFile.trn' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1...
Hi I've got a query which shows and creates two different execution plans based on the value of a variable....the problem is that one is significantly slower than the other and it only happens with a particular value.
basically the query looks like this....
select
from tblA a
join tblB b
join...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.