When is TempDB Used? That’s a very good question! In this SQL Server Administration quick tip, we will be discussing about, when the TempDB SQL Server system database is used. About the TempDB System Database in SQL Server TempDB is one of the system databases of SQL Server. As its name implies, it is … Read more…
This article is about SQL Server’s TempDB System Database, and it is from my eBook: Tuning SQL Server (Second Edition) Table of Contents | Sample Chapter | Learn More Introducing the TempDB System Database in SQL Server The tempdb system database in SQL Server is one of the databases that are shipped with every SQL … Read more…
Many people ask: “Where are temporary tables stored in SQL Server?” and that’s a very good question. There are many cases where we need to create temporary tables in SQL Server and for various reasons. Such reasons may include: Breaking the logic of a large and complex SQL Statement in smaller portions of code. Increase the … Read more…