Just to keep the start to the new year cheerful here's my favourite...

"Good Health is merely the slowest possible way of dying"

Yes this does seem to force the execution plan to the 'quick' mode and for that I am grateful but...does anyone know the answer to the question about SQL Server's...

Returning to the theory that SQL Server may not be appraising the number of Logical IO's which cause Physical IO accurately I came accross the following.

According to “SQL Server...

Sorry about delay responding but I had some difficulty getting the profiler execution plans...there's a lot of information here. Suggest copying the profiler data and viewing under notepad in courier...

Thanks for response. The code was written into an insert trigger and subjected to repetitive soak testing (5-10 mins) for a range of initial record numbers (1000-100,000). At the start...