1. tsql - T-SQL calculate moving average - Stack Overflow

    https://stackoverflow.com/questions/26618353

    I am working with SQL Server 2008 R2, trying to calculate a moving average. For each record in my view, I would like to collect the values of the 250 previous records ...

  2. SQL Server 2017 on Windows and Linux | Microsoft

    https://www.microsoft.com/en-us/sql-server/sql-server-2017

    Bring Microsoft SQL Server 2017 to the platform of your choice. Use SQL Server 2017 on Windows, Linux, and Docker containers.

  3. Calculating Weighted Moving Average in SQL - SILOTA

    www.silota.com/docs/recipes/sql-weighted-moving-average.html

    SQL Recipes; Smoothing Data; Calculating Weighted Moving Average; Calculating Weighted Moving Average in SQL. A weighted moving average is a moving average where the ...

  4. Do I have to use OpenQuery to query a MySQL Linked Server ...

    https://stackoverflow.com/questions/8187234/do-i-have-to-use-open...

    I'm querying a MySQL linked server from SQL Server. I can query the linked server using OpenQuery as in the following example. SELECT * FROM OPENQUERY(MyLinkedServer ...

  5. SQL Server 2000 Performance Tuning Tools - SQLTeam.com

    www.sqlteam.com/article/sql-server-2000-performance-tuning-tools

    This article comes to us from Brad McGehee at www.sql-server-performance.com. It discusses various tools that can be used for performance analysis and enhancement in ...

  6. How to analyse SQL Server performance - rusanu.com

    rusanu.com/2014/02/24/how-to-analyse-sql-server-performance

    So you have this SQL Server database that your application uses and it somehow seems to be slow. How do you troubleshoot this problem? Where do you look?

  7. sql server identify long running queries

    www.sqlservergeeks.com/sql-server-identify-long-running-queries

    sql server identify long running queries. It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the ...

  8. Top 10 SQL Server Management Studio (SSMS) Tips and …

    www.sqlmatters.com/Articles/Top 10 SQL Server Management Studio...

    I thought I’d share a few tips and tricks that I’ve picked up along the way with SQL Server Management Studio. These are some of the features which I’ve found ...

  9. OVER Clause (Transact-SQL) | Microsoft Docs

    https://docs.microsoft.com/.../queries/select-over-clause-transact-sql

    UNBOUNDED PRECEDING Applies to: SQL Server 2012 through SQL Server 2017. Specifies that the window starts at the first row of the partition.

  10. SQL Server Functions: The Basics - Simple Talk

    https://www.red-gate.com/.../sql-server-functions-the-basics

    Listing 4: Running a query with a scalar function. Unfortunately, SQL Server is not terribly intelligent in the way that it works with scalar functions.