WEBINAR: SQL Server Table Partitioning – DOs and DON’Ts (Imported)
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.
Level 300
Language: BULGARIAN
ENG Subs: NO
Audience: DBDevs, DBAs, Data Specialists, BI Specialists
| Module 1 | PARTITIONING OVERVIEW |
| Unit 1 | Short Introduction |
| Unit 2 | What is Table Partitioning |
| Unit 3 | Benefits of Partitioning |
| Unit 4 | How the partitioning works (DEMO) |
| Module 2 | USING RANGES |
| Unit 1 | Right & Left Ranges |
| Unit 2 | Right & Left Ranges Part II |
| Unit 3 | Should we rely on LOADING/DELETE directly into the partition table |
| Module 3 | CONCLUSION |
| Unit 1 | Conclusion |