Working with Very Large Tables Like a Pro in SQL Server 2019 — Guy Glantser

"A common use case in many databases is a very large table, which serves as a fact table or some kind of activity log, with an ever-increasing date/time column. This table is usually partitioned, and it suffers from heavy load of reads and writes. Such a table presents a challenge in terms of maintenance and performance. Activities such as loading data into the table, querying the table, rebuilding indexes or updating statistics become quite challenging.
The latest versions of SQL Server, including 2019, offer several new features that can make all these challenges go away. In this session we will analyze a use case involving such a large table. We will examine features such as Incremental Statistics, New Cardinality Estimation, Delayed Durability and Stretch Database, and we will apply them on our challenging table and see what happens..."

Get Resources: https://www.madeiradata.com/post/work....