when I run the function fn_dblog to get some info from the SQL Server transaction log - I am after what is deleting something sometimes only - I have set up a server side trace for this now.
I thought I could see something related to my mysterious deleting from the transaction log, but they are backed up every 15 min...
anyway, while looking at the transaction log using the query below, I see this:
select * from fn_dblog (null, null) where spid is not null order by [begin time] desc
is it because the inserted rows did not fit in a page of the clustered index, and therefore had to be created somewhere else allocating a new page for them?
could this be an indication that the FILLFACTOR is too high?