Working with Very Large Tables Like a Pro in SQL Server 2017

Target Audience:

This session is intended for database administrators and database developers, who have a basic understanding of indexes, statistics and partitioning.


A common use case in many databases is a very large table, which serves as a fact table or an 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…

Why I Want to Present This Session:

As a data platform consultant, I encounter a lot of case studies with customers that involve very large tables. I see people struggle with such tables again and again. Throughout my career, I gained experience with working methodologies against such tables, and I believe that this session can be useful to a lot of DBAs and developers. I have already presented this session in several occasions, such as PASS Summit and SQL Saturdays, and I received very good feedback.

Additional Resources:

The following two tabs change content below.
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.
Previous Post
Demystifying Dynamic SQL
Next Post
Query Store without SQL 2016 = Open Query Store

1 Comment. Leave new

Eugene Meidinger
September 14, 2019 10:05 am

You do a great job articulating why we should care about this problem and this session in particular. Well, done.


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.