What challenges do you face when dealing with tables that are over a terabyte in size? How do you index them? What do their statistics look like? How do you update them, and how do you fight against index fragmentation? How does all of this affect the estimation of the amount of data and how to tune queries involving very large tables?
Speaker: Milos Radivojevic https://SQLBits.com/speakers/Milos_RadivojevicSpeaker Blog: https://milossql.com
Speaker BIO: Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers. He is co-leader of the SQL Server PASS Austria
https://SQLBits.com/Sessions/Dealing_with_Very_Large_Tables_in_SQL_Server
Tags:
