window functions

SQLServerCentral Article

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

12,758 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

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

Read the latest Blogs

Forums

Setting Up SQL Server 2019 for Optimal Performance

By water490

Hi I have a very large database (600GB) that I am looking at creating. ...

Restart SSA in a job?

By jbalbo

Hi, I have a job that rebuilds indexes after a refresh of a replicated...

Intermittent sqlmail success - troubleshooting

By brambor

Microsoft SQL Server 2016 (SP2-GDR) (KB4583460) - 13.0.5103.6 (X64) SQLMail Account configured with SSL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers