• Is the query valid on a 64-bit system? The numbers retured were very large, something like several TB.

    Beginning SQL 2005, we don't install 32-bit version anymore. We always set max server memory. But I don't know what's the best way to determine MemToLeave requirement on a particular instance.