Aggregate Transform

External Article

SQL Server Data Aggregation for Data with Different Sampling Rates

  • Article

In the emerging "Internet of Things", there are multitudes of devices collecting data at differing sampling rates. Integrating this data so the data has a common granularity in time is important to not only allow for accurate analysis and mining, but it will also aid in reducing the amount of data to be stored and processed.
In this tip, we will demonstrate how to use the T-SQL AVG function and GROUP BY clause to transform data collected from two devices sampling at 100Hz and 40Hz to one row per second.

2014-12-24

7,922 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

South Kerala Tour Packages

By indiaboundtour

South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...

Black Corgi Chihuahua Mix – Unique Look and Personality

By dogshabit

Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers