Using Pivot, coalesce, datediff  Read more...

This is a script to restore all databases from backups places in a folder.  Read more...

SQL Server Stored Procedure Execute Count Script ..   Read more...

This script is an example explaining how to write DML using CTE.  Read more...

The script below executes on the first of every month and moves files from source to destination location.   Read more...

A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.  Read more...

List all the instances with their paths as stored on CMS.  Read more...

This procedure drops any object if it exists not including temp tables.  Read more...

Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.  Read more...

Simple T-SQL Script to know whether your SQL Server is running on a Physical box or a VM. Note: This Script works only on 2008R2 SP1 and above.   Read more...

A script to create MERGE statements with data for specific tables.  Read more...

Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio. It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.  Read more...

A 2012 update to "Reindex Procedure with a Twist (or two)":   Read more...

Function to know column Exists or not in the Table?  Read more...

Daily maintenance script to check on backups  Read more...

Returns a summary of CPU usage by SQL Server over the last 4 hours (default). Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.  Read more...

Script for preventing the volumes of the transaction logs from filling.  Read more...

Finds the publisher, publisher database, and publication that your subscription table is replicated from.  Read more...

I wrote this script to help me locate the publisher, publication, published database, and source object for destination tables which might not be named the same or when you are in a large replication topology with dozens of publications.  Read more...

Sometimes you want to copy all the alerts that you've got set up on one server to add them to another  Read more...