A common use case in many databases is a very large table, which
serves as 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 2017, 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...
(no tags)
The video is not available to view online.