So I get credit for all further answers, how nice :-P.

I also asked for sample data > (insert statements).

I'll go 1 up and ask for the actual execution plans for all top 4 queries > http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Can you [re]post the rowcount for all tables, current fill factor and space used? I just want to have the correct info to rebuild test tables (unless you don't mind sending a backup over here, which I wouldn't really expect to get at this point :hehe:)