« Tips for installing SQL Server 2008 on Windows 7 | Main | Create Standards for SSRS Reports in Visual Studio »
Wednesday
Nov252009

Demystifying SQL Servers TempDB

DateWednesday, November 25, 2009 at 1:52PM

Cindy Gross on her msdn blog of Troubleshooting, tips, and general advice about SQL Server has a post that consolidates information and links to information on TempDB.  The article has some very simple basic advice as well as a number of links to other resources with more detail.

Compilation of SQL Server TempDB IO Best Practices.

http://blogs.msdn.com/cindygross/archive/2009/11/20/compilation-of-sql-server-tempdb-io-best-practices.aspx

As an avid and explicit user of temp tables I have long since been behind the idea of high performance drives for the TempDB.  Does anyone have any performance and durability data on the use of SSD for the TempDB.

AuthorJoshua Lynn | CommentPost a Comment | |

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.

Notify me of follow-up comments via email.