The MSDB database is the database with the backup and restore system tables. Here are the backup and restore system tables and their purpose: - backupfile - contains one row for each data file or log file backed up - backupmediafamily - contains one row...

SOLUTION The database backup and restore operation is an excellent method which is available to database administrators who need to upgrade a database from SQL Server 2000 or SQL Server 2005 to SQL Server 2008. Moving a database using backup and restore...

SQL Server Terminology Database – A database is an organized collection of data for one or more purposes, usually in digital form. Relational Database – A relational database stores data in separate tables instead of placing all data in one large table.....

Below is the query that tells the information about the SPID which has high Memory Usage in SQL Server. SELECT mg.granted_memory_kb, mg.session_id, t.text, qp.query_plan FROM sys.dm_exec_query_memory_grants AS mg CROSS APPLY sys.dm_exec_sql_text(mg.sql_handle)...

Types of Pages in SQL Server Pages are the basic storage unit of SQL Server. There are several pages available in SQL Server. Each page can store upto 8KB of data. Below are the various types of pages available in SQL Servers: Data Pages Data rows with...