Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Articles with tag Aggregate Transform Rss

Search for any content tagged aggregate transform

   Items 1 to 2 of 2   

SQL Server Data Aggregation for Data with Different Sampling Rates

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.   Read more...
By Additional Articles 2014/12/24 | Source: | Category: aggregate transform
Rating: (not yet rated)  Rate this |   Briefcase | 7,372 reads

Using the Aggregate Transform - SQL School Video

MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.  Read more...
By Brian Knight 2008/12/04 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 4,400 reads
   Items 1 to 2 of 2