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
Powered By WP Courseware