Database Normalization in SQL with Examples

Gouri Shankar provides an overview of normalizing a database.

Handling Aggregations on a Poorly Designed Database

When the database design is not great, you may have to write some creative queries to get what you need.

The "Median" Function

A quick search without an index

Alex Chamchourine explains how he managed to find a row in a billion row table without an index.

Calculate the Days Between Orders

Introduction to PIVOT operator in SQL

Learn how to use the PIVOT operator in SQL in a step-by-step manner.

Efficient Solutions to Gaps and Islands Challenges

Window functions are useful for solving many SQL queries. In this article, Ed Pollack demonstrates how they can be used to analyse baseball winning streaks.

Calculate Moving Averages using T-SQL in SQL Server

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]

Calculate the Days Between First and Last Orders

SQL Server Attach and Detach Database Examples

In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.