Script to Generate Job Scripts – SQL Server

The following script generates the “Job Details” as in script form. I struggled a lot to migrate jobs from one server to another server and decided to write a script …

Read More

SQL Server Space Usage

In order to determine the space used by a database in SQL Server we use the following command The above command, on execution gives two tables as output. First table …

Read More

SQL Server Indexes – An Insider Look

Introduction There was a time where many have not realized the importance of indexes in database world. Indexes were predominantly used to decrease the execution time of a query without …

Read More