DDL and DML in SQL Server
SQL Server System Databases
SQL Server System Tables
Joins in SQL Server
SQL Server - Indexes
CTE in SQL Server
SQL Server - Locks
Optimization Techniques in SQL Server
How to Setup NDF Files in SQL Server
Deadlocks in SQL Server
Transactions in SQL Server
Difference UDF vs Stored Procedure
SQL Server Triggers
SQL Server Isolation Levels
SQL Server Pivot Tables
SQL Server - Group By Statement
SQL Server - Find Second highest Number Query
SQL Server - Recursion in User Defined Function
SQL Server Error Handling
Difference Table Variable and Temporary Table
SQL Server - Temporal Tables
User Defined Functions - SQL Server
Stored Procedures - SQL Server
SQL Server System Databases
SQL Server System Databases are essential for the proper functioning and management of SQL Server. There are several key system databases, each with its unique purpose:
master: This database records all the system-level information for an instance of SQL Server. It includes information about logins, linked servers, system configuration settings, and user databases.
msdb: Primarily used by SQL Server Agent for scheduling alerts and jobs. It also contains backup and restore history tables.
model: The model database is a template database used for creating new databases. Any changes made to the model database will be applied to new databases created afterward.
tempdb: A temporary workspace used for storing temporary tables, temporary stored procedures, and any other temporary data. It is recreated every time SQL Server restarts.
resource: Hidden and read-only, this database contains system objects included with SQL Server. You won't see it in the list of databases, but it's crucial for the internal functioning of SQL Server.
Would you like to dive deeper into any specific system database or learn more about how they interact?