by Data & SQL Storage Performance Team via SQL Server Performance on 4/14/2007 12:33:00 AM
Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so temporary about it? TempDB is always present on each SQL Server instance and can be a determining factor of your overall performance. In many ways tempdb could be named scratchdb or pagefiledb. The following papers will help you understand what goes into tempdb and how to plan your deployments. These articles are for both developers and administrators.
Working with tempdb in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx
Capacity Planning for tempdb
http://msdn2.microsoft.com/en-us/library/ms345368.aspx
Enjoy..
Tony Voellm
Original Post: What’s so temporary about tempdb?
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.
