TempDB 101 Plus

Speaker: Andrew J. Kelly TempDB isn't your ordinary user database and definitely shouldn't be treated like one. The usage patterns and internals dictate that the configuration, monitoring, and usage be done in a different way to get the best performance. You'll see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB. Learn how to detect the memory and space usage associated with various users in TempDB, along with some of the most common performance-related scenarios that you'll encounter with a well-used TempDB database. In addition, you'll learn the difference between temp tables and table variables and when to use one over the other. Both DBAs and developers need to understand the concepts of TempDB, including how some relatively simple changes in code or configuration can potentially make a huge difference in the overall performance of SQL Server.