TempDB configuration for people in a hurry

If you’ve ever had to play administrator to a SQL Server instance, you’ve probably had to deal with TempDB data or log files that have grown unexpectedly. I know a lot of folks have had to do this, because the most read post on this site is “Help! My tempdb database won’t shrink!

Consider it a right of passage of sorts. Also, consider that it might be entirely avoidable. Let me show you.

Continue reading