DBCC MEMORYSTATUS – Memory objects and the SQL Server Query Optimizer So one of the features I had a hand in building in SQL Server 2005 is really useful for helping SQL Server work well in Explore