SQL DBA

How to Fix a Full TempDB in MS SQL Server TempDB is a critical system database for temporary operations. A full TempDB can cause performance degradation and failed transactions. Follow these steps to resolve and prevent issues. 1. Diagnose TempDB Space Usage Check overall usage: USE tempdb; EXEC sp_spaceused; Detailed space breakdown: SELECT SUM(user_object_reserved_page_count) * … Read more

Microsoft SQL Server consists of logical and physical files that store and manage database data. Logical files refer to the representation of physical files in SQL Server. Logical File Types in SQL Server Primary Data File (MDF): The main database file. Contains the database schema and data. Every database has exactly one primary data file. … Read more

For a seasoned MSSQL DBA, understanding the intricacies of system databases is critical for performance tuning, disaster recovery, and maintaining system integrity. Below is a comprehensive breakdown of each system database, including their roles, internal structures, best practices, and common challenges. 1. MASTER Database 2. MODEL Database 3. MSDB Database 4. TEMPDB Database 5. RESOURCE Database