SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Working with Very Large Tables


Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”. The session was hosted in the PASS Database Administration Virtual Group. You might be surprised, but I was talking about how to work with very large tables in SQL Server. I was also talking about how to leverage some of the new features in SQL Server 2014/2016 (“like a pro”) in order to make your life easier when you work with those very large tables.


Working with Very Large Tables in SQL Server 2016

Image courtesy of marin / FreeDigitalPhotos.net


The session focuses around 4 areas of working with very large tables:


  • Managing the table using partitioning or the new Stretch Database feature in SQL Server 2016
  • Querying the table efficiently with the New Cardinality Estimator, Incremental Statistics, and more…
  • Loading data into the table with Delayed Durability transactions
  • Maintaining the table with online index rebuilds and other cool stuff…


Learning from the past, we decided to split the session into two parts. This way, we had enough time to cover all the stuff I wanted to share with you, and there was also enough time for questions.


Here is the recording of part 1:



And here is the recording of part 2:



You can download the complete set of materials (presentation and scripts) for the entire 2-part session.


I hope you enjoyed the session, and I hope to see you again soon…



The post Working with Very Large Tables appeared first on Madeira Data Solutions.

Guy Glantser

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.


Leave a comment on the original post [www.madeiradata.com, opens in a new window]

Loading comments...