One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of ...

Another performance improvement comes in SQL Server's temporary workspace, TempDB. Taking advantage of the in-memory OLTP feature, which eliminates a bottleneck at the data latching layer ...

If your application uses the tempdb database a lot, and causes it to grow larger than its default size, you may want to permanently increase the default size of the tempdb file to a size closer to ...

SQL Server 2008 provides a minimal set of tools ... Also, a majority of cursor operations occur in tempdb, so a heavily used tempdb will be even more overloaded with the use of cursors.