window functions

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

6,493 reads

Introduction to T-SQL Window Functions

  • Article

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

4,353 reads

Blogs

Social: Respecting Names

By

This is a non-technical post, and my opinion. If you don’t want to read...

Proud to present at this year’s VMworld 2020 conference

By

I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...

Daily Coping 7 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to be an MVP

By Kathi Kellenberger

Comments posted to this topic are about the item How to be an MVP

rename sa

By ramyours2003

i want to  rename the sa login with different name , is the jobs...

Does anyone have experience of using securetrading.net as a data src within ADF?

By wood.kieran

Hi, Does anyone have experience of using securetrading.net as a data source within Azure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

BDC Storage

See possible answers