# The "Median" Function

• QotD Question

5 (3)

2020-02-14

# Calculate the Days Between Orders

• QotD Question

5 (3)

2020-02-10

# Using TOP with ROW_NUMBER

• QotD Question

5 (2)

2020-02-07

# Calculate Moving Averages using T-SQL in SQL Server

• Article

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 […]

5 (4)

2020-02-04

# Calculate the Days Between First and Last Orders

• QotD Question

4.5 (2)

2020-02-03

# An Intro to SQL Window Functions

• Article

Learn about some window function basics in T-SQL

2019-08-05

# What’s the Difference Between PERCENT_RANK and CUME_DIST?

• Article

Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.

3.75 (4)

2019-06-27

# Christmas 2018 Trivia

• QotD Question

2018-12-24

# Introduction to T-SQL Window Functions

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.

2018-06-28

# The Lonely Count

• QotD Question

2016-01-07

## Blogs

### Creating a New Sequence–#SQLNewBlogger

I wrote about sequences in an editorial recently and decided to start using them....

### An All Star Lineup for EightKB

An online conference is coming on June 17, 2020 that is full of high...

### How should I store currency values in SQL Server?

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

## Forums

### Filestream or Filetable or None...what to be used?

By Feivel

I've been assigned with a project that includes converting the columns in the existing...

### How to force MS SQL to select a partition instead of making a full table scan

By svenflock

Hi all, I am currently designing a datamart layer in MS SQL 2016 Enterprise....

### Daily 3 Coping

By Steve Jones - SSC Editor

Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/

Visit the forum