Скачать или смотреть Dealing with Very Large Tables in SQL Server

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_Ra... 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_...
Tags: