I would like to know more about this. The article does not explain what occurs when this is not enabled, nor does it mention if there is a performance hit,...

I have the same issue on one SQL 2005 St. Edition server (sp3). But on other servers of the same version, the memory settings are not grayed out. Did you...

I found the problem, and now am seeing the same query execute in sub-second time. I tried rebuilding the indexes that were carried over from the SQL 2000 database and no change, then...