Disk Space Alerts Based on Threshold Value

This script will drop a mail for sql drives if space on drives is below set threshold value. Log drives with 15 and data files drives with value of 10% as threshold value of free space.

Constraints renaming

Rename constraints to enforce naming conventions.

List Expressions and Values of Variables in SSIS package

Variables can be direct text or Expressions. It's handy to be able to get both at one pass. This little script does that.

Data Compression

This script is used to compress tables and indexes. It is designed for page compression on all. Just a little ditty to help with our EDW storage and processing.

First day and last day of a week

This scripts calculates the first day and the last day of a given week

Set Proper Name Case Function

This script sets the proper case in a "full name" field

Short Script to Backup All User Databases

Backup All User Databases with sp_msforeachdb

Get FirstDate and LastDate of Every month from two Dates

Get FirstDate and LastDate of Every month from two Dates.

Like IF we have @date1='05/02/2015' and @date2= '11/25/2015' then we will get list of first date and last date from month 5 to 11.

SELECT ID,FirstDate,LastDate,Month,Year FROM [GetFLDatelist](@date1,@date2)

Who are connecting to database and disconnect ...

When you want gain exclusive access to database in order to restore database

Rebuild index selectively

Rebuild index is expensive most time. So you don't rebuild all index blindly.