2023-02-03 (first published: 2023-02-02)
8 reads
2023-02-03 (first published: 2023-02-02)
8 reads
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
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
2008-12-04
4,418 reads
I second what Antares said. I see the error because there are two or more rows that have the info that you are deleting. So if you query a table and get the customer firstname, lastname and if you want to delete John Smith, chances are that there are many John Smiths in the table. […]
2004-06-07
sp_helpserver will tell you which server are the linked and remote servers. You may then search syscomments table to find out those procedures.
2003-06-03
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers