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.
Category: RDBMS
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
Get the Edition and Version Information of SQL Server
As soon as you start a new job, the first thing you should do is look up the version and edition details of the database
Cursors in SQL Server
An object called a database cursor makes it possible to browse through the rows of a result set. Unlike TSQL commands that operate on all
Big Data & SQL 