sp_PerfSQ

A diagnostic tool for identifying Performance features of active SQL Queries. It collects performance detail from DMVs for queries with executing requests and is designed to demonstrate and quantify Query Shaping optimisation techniques by: quantifying query workload and throughput characteristics providing behavioural descriptors of potential performance inhibitors - refer column ThrottlePotential The ThrottlePotential column is […]

T-SQL query to copy data from one database to another database

T-SQL query to copy the rows of all the tables from one database to another database only if they have rows in Source DB and exact same Schema in both Source and Destination DB.

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

STRING_SPLIT with Index as Table-Valued Function

Function to pad Bigint with leading zeros or other single characters

Function to pad bigint with leading 0's or other single character

Generic trigger for maintaining the Audit Log

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

Compare Table Contents Procedure

Compare the content of two tables for differences

Fix all orphaned users in a database

Fix orphaned users on a restored db

Building calendar table using MTVF

This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/

Calculate two internships

Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd