A. A. Do the following.
- Configure tempdb to be in RAM for 2 MB. Use SQL EM or sp_configure.
- Stop and restart SQL Server.
- Add a new device for tempdb. Do not call it temp_db - any other name should be ok
- Make that new device a 'default' device; make sure no other device is marked as default, especially master. You can check/change default status either using SQL EM, or the sp_diskdefault stored-procedure. Both are fully described in the books-online.
- Configure tempdb to NOT be in RAM (set value to 0)
- Stop and restart SQL Server
- Re-mark whichever device(s) you want to be default.
Contributed by Neil Pike