Replace special char and keep what you want  Read more...

This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.  Read more...

ERRORFILE and MAXERRORS option are rarely used important arguments in BULK INSERT so, I will try to highlight the use of these arguments in this script.  Read more...

This script gives a server level snapshot of recent security changes  Read more...

A short compression script that will compress all tables or indexes.  Read more...

A simple script that transfers triggers from one database to another.  Read more...

This script will produce a report on the status of the Always On replication.  Read more...

List all active Jobs in SQL Server with the details of the schedule.  Read more...

Converting to datetime a char field having several possible date formats  Read more...

The script works through the CMS you have set up to manage your environment and gathers various server information.  Read more...

script to return query result transposed.  Read more...

Performance Base Line Report from SQL Server DMVs and Perfmon counters  Read more...

Script to reorganize all indexes on all tables in user databases  Read more...

Script to generate script to detach or attach user databases   Read more...

A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly  Read more...

Know you database size  Read more...

Checking Backups on your SQL Server  Read more...

This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.  Read more...

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.  Read more...