Deleting Duplicate batches of rows

All of us have problems with Duplicate rows, here is a simple and efficient way of removing duplicate rows

A Generic Histogram Generator for SQL Server

Histograms help people analyze large amounts of data, whether you display them as tables or as charts. This article shows you how to do both.

Dynamically controlling the number of rows affected by a SQL Server query

One thing you may need to do is dynamically return a set amount of rows based on user input. This could be for a search function, reports, dropdown lists or whatever. Instead of hard coding a set value you would like to pass in a variable that will then determine the number of rows to return. How can this be done with T-SQL?

Views created per table

Collect the views and schema for a table!

sp_getreferences

This script gets the f_key and p_key references from and to another tables

sp_desc

This script gets the object description, and works quicker than sp_help

Format Date

This scripts help to format date in different languages

Building Parent-Child Table Tree information

How many times have you wanted to know which child or grandchild records exists for a parent record? SSMS doesn't make this information easy to find beyond one level. New author Narasimhan Jayachandran brings us an article and a recursive solution.

Understanding INNER join in detail

This objective of the article is to give readers in depth understanding of INNER JOIN with different joining conditions.

Identity Columns