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

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.

Alter all/specific columns by double dynamic SQL

The script uses dynamic SQL twice
first to get the detail about the database structure and create ddl out of it
second to execute each DDL created

Paginating a SQL query result set

How to Paginate a query result set to keep from pulling the whole result set to the client side

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.

List of Stored Procedures modified in past 7 days

Provide list of Stored Procedures that have been changed in past 7 days.

Get Client IP Address in SQL Server

A function for getting Client IP Address in SQL Server