Crud.  Sorry Lynn... I got busy last night and forgot.

I'd still call MS.

I guess I'd hum a rock at MS and see what they have to say.

I don't know if cutting down on the number of joined tables will help but it can't hurt.  Here's an example of what I use pared down to what you...

I think people spend way too much time looking at counters.  Right click on the instance in the Explorer Window, click on reports, and follow your nose for the real...

And DO understand the security ramifications of using SET TRUSTWORTHY ON.  It may not be a problem or... it may.  "It Depends" but you won't know until you read about...

The only problem with using date in such a fashion is that it must be certain and continuous without any gaps or duplication.  Of course, there are rabbit holes for...