Time Series with SQL Server 2022
summary
SQL Server 2022 can store and query time series but needs manual work: a 15‑day, 82M‑row performance dataset compresses from ~28GB (clustered index) to ~400MB with clustered columnstore and to ~231MB with archive compression, while InfluxDB v1 stores the same in ~91MB. Retention isn’t built in (data deletion policy from Edge is missing), so use partition switching to drop old data or jobs to emulate continuous queries and do downsampling. New helpers like date_bucket and generate_series ease time‑grouping and gap‑filling.
AI-written summary · about
chapters (12)
- 0:00Introduction to time series
- 2:33Defining time series data
- 7:07Relational vs time series
- 10:45The importance of time series
- 12:30SQL Server for time series
- 15:00Introduction to InfluxDB
- 20:17InfluxDB design principles
- 26:19Storage optimization in SQL
- 33:54Retention and partitioning
- 40:23Partitioning demonstration
- 42:11Querying time series data
- 48:33Conclusion and Q&A
related talks
07mTime Series Databases
49mThinking in time series, the new solution to your pro...
16mTVStore: Automatically Bounding Time Series Storage via Time-Varying Compression
28mTick Tock: What the heck is time-series data?
47mBack to the Future of Time Series Data
48mLevel up your Big Data game with Redis Time Series!
20mColumnstore Index Compression in a Nutshell
12mTime to awesome: InfluxDB and the AWS environment