Thanks Jon. I'll read up on this.

FYI -

max degree of parallelism = 0

Locks = 0

Cost = 5

Query waits = -1

I'm guessing this is the out the box setup as I've never changed it. Does this ring alarm bells or seem perfectly reasonable?

I have 16 processors @ 2.4 GHZ. 58 GB memory with 48 GB allocated to SQL.

Cheers