Recent content by Gawaine79

basically says that there's another log file in between file 1 and file 2....

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...

not typically used

one thing that i forgot to mention is that the select is usually selecting the top 250 from this query... at most selecting the top 1000

it's actually used very often..and there are other where conditions and derived tables (all conditions and derived tables are the same through out)...it usually runs in 1-2 seconds but when the value = 2 it can take up to a minute to run..usually around 40 seconds. the index/selectivity would...

alter table x add Code varchar(2) update x set code = case when text like '%all euro' then 'EU' when text like '%HGU_SEC' then HG' end

1's 1938349 2's 73512 3's 347111 4's 114041 5's 108295 these 5 represent about 99% of the total data in the table. statistics are run every week for us. :(

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...