Hi,

Your pages are only using 49% of the available space. This is a particular behaviour of heaps that have frequent deletes. I have blogged about this behaviour.

Heaps of Trouble

Try build a clustered index on the table and see if that improves your query time.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]