In Tsql the "show [estimated] accesspath"-options are great to check if they match whatever you've supposed it was going to do. This works fine for single query tuning. When using...

I've just noticed that my VMsize seems a bit high. (700mb memusage / 1100mb VMsize)

Still searching why.

Jobi