I've found the cause of the problem.

All of our data files had the file extension '.mdf' (don't blame me, I didn't create the database) Presumably SSMS looks at the...

Thanks for your reply Alex.

Any idea why this limitation was introduced?

regards

ian

Thanks David

Thanks JP. I've been struggling to find a solution to this one for quite a while. It's good to know we're not the only ones with this issue.

Ian

Did anyone find a solution to this one? We have the same problem.

Ian

Thanks Clifford - an excellent summary, explains the issues very clearly.

Ian

In a way that answers my question. I was really wanting to know if there was a hard and fast rule stating that clustered tables will be quicker to query.

If you...

I'm sure you're right that it's not feasible to understand everything that's going on in tempdb. It's more curiosity on my part, having seen references to these objects in Profiler and...