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

This script is an example explaining how to write DML using CTE.  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...

something to help working with ssms.  Read more...

All Index Size  Read more...

Dynamically create and/or execute a pivot sql statement against a provided table.  Read more...

Get a report of backups older than 60 days.  Read more...

this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.  Read more...

This is an example of how to Cache Query results on the Server side then page though the results   Read more...