Script to restore the entire databases from the backup directory just by passing the backup directory.  Read more...

Script to Check the Database Backup duration of entire instances  Read more...

Script to get the Database restore history details including with the files by which the database is restored.  Read more...

Script to get the database backup history on SQL Server 2000/2005/2008  Read more...

To recreate log files on sql server  Read more...

This code generates merge scripts in the form of individual stored procedures for each table within a specified database. Once executed, simply highlight the results within the following columns altogether and past into a new window: TABLE_SQL, SET_OPERATOR, AND_OPERATOR, COLUMN_SQL Enjoy  Read more...

Template to create a Type 6 slowly changing dimension stored procedure  Read more...

Populate a calendar table with user set interval start and end datetime values.  Read more...

Populate a calendar table with user set interval start and end datetime values.  Read more...

Populate a calendar table with user set interval start and end datetime values.  Read more...

Populate a calendar table with user set interval start and end datetime values.  Read more...

Have you ever wanted to dynamically unpivot a table?  Read more...

This script will help in identifying file size of primary file, log file and all partition files. This include free space available and space used for each file in a database.  Read more...

Get the list of the tables on the server which dont have the clustered index.  Read more...

Create a stored procedure that will send the result of a query as an html table from the database mail.  Read more...

Create Copy of database with new name.  Read more...

This procedure let you list [optional] by table: -Foreign keys -Primary key -Indexes   Read more...

Creates compression scripts for all objects in all databases in the instance.  Read more...

This will name Ignite SQL hashes that have not been named yet, based on the object (or batch) they are within.  Read more...

Here's a quick query you can run across all your servers (2012) to find a wealth of information like service pack, edition, number of CPUs and RAM. Even more is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.  Read more...