Tempdb

Making a more reliable and flexible sp_MSforeachdb

While the system procedure sp_MSforeachdb is neither documented nor officially supported, most SQL Server professionals have used it at one time or another. This is typically for ad hoc maintenance tasks, but many people (myself included) have used this type of looping activity in permanent routines. Sadly, I have discovered instances where, under heavy load and/or with a large number of databases, the procedure can actually skip multiple catalogs with no error or warning message. Since this situation is not easily reproducible, and since Microsoft typically has no interest in fixing unsupported objects, this may be happening in your environment right now

Restore

Log File VLFs

SQL Server Port Number Identifier

Find SQL server port number for SQL 2000, 2005, 2008 and 2008 R2

VLFs in Log Files

New Log Files

Monitoring Table Size Growth in SQL Server

This article demonstrates how to monitor table size growth in SQL Server.

mixed_extent_page_count

Monitor User Connections in SQL Server

This article explores the causes and remedies for applications failing due to too many open connections to SQL Server.