Speaker: Margarita Naumova
Topic: SQL Server Table partitioning – DOs and DON’Ts
Summary: Dealing with billion rows of tables in SQL Server is not easy, resolving performance issues when working with them either. But table partitioning, just the same as indexing, is not a silver bullet. There are a few important things we need to consider before choosing a partitioning strategy. In this demo-rich seminar, we will start with those key points. We will understand what the partitioning main purpose is and how it helps for better data management and maintenance. And when we can get improvement in the performance. Shall we divide our Datawarehouse fact table or a 50GB table in an operational database into partitions or we could just create an index to improve query response time? Those are just some of the questions we will find answers by attending this seminar.
ENG Subs: NO
Audience: DBDevs, DBAs, Data Specialists, BI Specialists
Upcoming EventsCurrent Month