Introduction to Partitioning

Uwe Ricken

The technical partitioning in SQL Server is often avoided because a first look at this ingenious feature conveys a high degree of complexity. This session impressively demonstrates that partitioning can actually be very simple.
Table partitioning has so many advantages that you, both as a DBA and as a developer, should familiarize yourself with the basics to assess whether partitioning can solve daily problems. In this session, the basics of partitioning are shown and the – apparent – complexity reduces to absurdity in a few minutes. After this session, skeptics will surely rethink their opinions and reservations.
• What does partitioning mean?
• Areas of application of partitioning
• Elements for providing partitioning
• Partitioning in action