SQLBits 2022
Partitioning for Beginners
Introduction of areas for 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
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
Speakers
Uwe Ricken's other proposed sessions for 2026
Demystifying Clustered Indexes in SQL Server - 2026
Evolution of User-Defined Functions in Microsoft SQL Server - 2026
How to properly handle LOB data in SQL Server - 2026
Leveraging JSON in Microsoft SQL Server - 2026
Uwe Ricken's previous sessions
Security techniques for cross database access
Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot.
Learn how to securely access data in other databases without breaking the bank.
Partitioning for Beginners
Introduction of areas for partitioning for Beginners
Why is SQL Server waiting for what?
You are wondering why SQL Server is waiting endless for a request and you don't know what is going on inside? A look behind the curtain with comon scenarios will help you to understand and solve long waits in SQL Server.
Inside statistics-a guessing game
A query was running fast yesterday and today it suffers from performance problems. What will you do?
- restart the server (did work)
- drop the procedure cache (read in a blog article)
- get a coffee and pass in review this session about statistics
Deep dive into the secrets of Temporal Tables
Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.
Daily problems with indexing and its-possible-solution
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution