The underlying tables which store the metadata for a certain database are called system tables. A system table called sys tables is used to keep
Category: SQL Server
SQL Server Administration, Development and Maintenance
Get the information about the backup and restore operations
The msdb database keeps a complete record of every SQL Server backup and restore procedure performed on a server instance. The data for the SQL
SQL Server Stored Procedures, Triggers and Cursors
The articles about SQL Server stored procedures, triggers, and cursors that have previously been posted on this blog are collected here. For quick reference only.
List of Scheduled Jobs – SQL Server
Scheduled administrative tasks, referred to in SQL Server as jobs, are carried out by SQL Server Agent which is a crucial component of SQL Server
Get the list of files and filegroups – SQL Server
One of the routine database administration tasks that a DBA performs is creating files and filegroups. The following query is quite useful for viewing, analysing,
Get the size of each table from a database – SQL Server
Checking the size of the tables is one of the duties that DBAs frequently perform. In order to do capacity planning, it is imperative that
Big Data & SQL 