Andrew, Thanks that is pretty much what I was looking for.

Lynn, thanks for your input - will note for future posts. Apparently "Forum Newbie" under my Author info is there...

Hello,

sample data:

RowId uniqueidentifier,

RowType INT (0 - data row, 1-check point row)

Value float (this is the value we want to sum within the range)

DateInserted DATETIME (Date row was inserted...

Thanks for your reply.

The table initially did not have associated statistics but I had created statistics for that index and also made sure I did an update statistics after the...

Hi, tempDB does not seem to increase. Thanks

The index I have is an unclustered index.

The statement that takes the most time is the

"insert INTO select". I tried to view the sql execution plan and also tried...