SESSION Details

Partitioning for Beginners

Do you have problems executing queries that take too long because the entire table always has to be scanned?
The maintenance window for index management and statistics management is no longer sufficient because the database (s) are too large?
Loading data blocks access to tables urgently required by the application?

If you are familiar with at least one of the problems mentioned above, you should deal more intensively with the partitioning of large tables. This session, which deals with the basics of partitioning, will introduce solutions by the help of partitioning for all problems mentioned.
- Loading of data no longer takes hours but seconds
- Index and statistics maintenance are carried out in a fraction of the time
- Queries can run faster because they only search in the partitions that contain the data they are looking for.

Feedback Link - https://sqlb.it/?7132

Starts: 10:10 10th Mar 2022
Ends: 11:00 10th Mar 2022

Q&As

Short Description
- Introduction of areas for partitioning for Beginners

Slidedeck Link

SQL Server Partitioning for Beginners.zip

Speakers

Uwe Ricken

Tags

AzureOn PremisesFuture DBAManaging Big DataOperational DatabasesDevelopingModellingOptimisingDatabase EngineManaged InstanceSQL 2019BeginnerHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.