Introduction to Indexed Views in SQL Server

This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.

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