tempdb is like a scratch pad for SQL Server. For example, if you order
a result set, it creates a worktable in tempdb and files the records in
there to sort them. Having tempdb in RAM can significantly improve
queies where you have to do a lot of ordering or sorting of data.
Typically I recommend having a tempdb in RAM if you have the extra
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com