Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.

SQL and the JOIN Operator

How the JOIN operator works, the different types of JOINs and relevant information about joining tables.

Retrieve consecutive records from the table based the value difference

Retrieve consecutive records from the table based the value difference

IN Operator

Kill Active connections

Simple Script to kill all active connection from current database.

Ultimate Alter Script generator

In development enviornment we always get the modifications in tables from developers.As far as my concern writing scripts is tedious work for us. I hope below script will help you.

T-SQL 2008

Celko's SQL Stumper: The Data Warehouse Problem

Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!

@@TEXTSIZE

SQL WHERE Clause Optimization

SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query to use it...