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. 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 ...

  3. Elastic Query Concepts with Azure SQL Data Warehouse ...

    https://docs.microsoft.com/en-us/azure/sql-data-warehouse/how-to...

    Elastic Query with Azure SQL Data Warehouse allows you to write Transact-SQL in a SQL Database that is sent remotely to an Azure SQL Data Warehouse instance through ...

  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 - Rolling sum / count / average over date interval ...

    https://dba.stackexchange.com/questions/107485

    In a database of transactions spanning 1,000s of entities over 18 months, I would like to run a query to group every possible 30-day period by entity_id with a SUM of ...

  6. Henk\'s tech Blog

    henkvandervalk.com

    A blog about IT workload optimization, performance, IT efficiency and SQL PDW.

  7. SQL Correlated Subquery - ZenTut - Programming …

    www.zentut.com/sql-tutorial/understanding-correlated-subquery

    In this tutorial, you will learn about the SQL correlated subquery, which is a subquery that depends on the outer query.

  8. Connecting Tableau to ElasticSearch (READ: How to query ...

    ryrobes.com/systems/connecting-tableau-to-elasticsearch-read-how...

    You are here: Home » systems » Connecting Tableau to ElasticSearch (READ: How to query ElasticSearch with Hive SQL and Hadoop)

  9. Use Analysis Services Templates in SQL Server Management ...

    https://docs.microsoft.com/en-us/sql/analysis-services/instances/...

    Create an MDX query from a template. In SQL Server Management Studio, open the instance that contains the tabular model you want to query. Right-click the database ...

  10. SQL Anywhere: A Holistic Approach to Database Self ...

    https://wiki.scn.sap.com/wiki/display/SQLANY/SQL+Anywhere:+A...

    This work, "SQL Anywhere: A Holistic Approach to Database Self-management", originally appeared in the Proceedings of the 23rd International Conference on Data ...