db-berater-server

SQL Server Real World Challenges

Troubleshoot real word scenarios with Microsoft SQL Server

Workshops

Partitioning with SQL Server
Workshop for Partitioning in Microsoft SQL Server

Partitioning

In this comprehensive workshop, we will delve deep into the principles, strategies, and practical implementation of data partitioning in SQL Server. Whether you’re a seasoned database administrator, developer, or data analyst, this workshop will equip you with the knowledge and hands-on experience needed to harness the benefits of partitioning for your database environments.

Database Developer for SQL Server
Improve your skills as a Database Developer for SQL Server

Development

In this workshop, we will cover a wide range of topics and techniques that are essential for modern database developers working with SQL Server. From fundamental concepts to advanced best practices, you’ll gain the knowledge and practical experience needed to excel in your role.

Improve Your Skills as a Query Tuner

During this workshop, you’ll gain the expertise and confidence needed to diagnose and fine-tune slow-performing queries, resulting in improved database responsiveness and end-user satisfaction. Whether you’re an experienced database administrator, developer, or data analyst, this workshop will equip you with the knowledge and practical skills to tackle the most challenging query optimization tasks.

Real World SQL Challenges with SQL Server

Welcome to our comprehensive resource hub dedicated to optimizing real world scenarios with SQL Server. Our mission is to provide real-world solutions for troubleshooting SQL Server issues and improving poorly performing queries and code.

Whether you’re a seasoned DBA or a developer looking to fine-tune your SQL skills, just connect to our SQL Server Instance and try to solve the given problem by yourself.

Do you have an idea for a challenge?
Drop us an email to sqlchallenges[at]db-berater.de.

 

SQL Challenge #7 – Dynamically added attributes

by | 2025-04-07 | Level 300, SQL Challenges | 4 Comments

SQL Server view optimization for student grading system: High CPU usage in [dbo].[exam_grades] view. Rewrite view to reduce load spikes after grade publication. Condition: Do not change table metadata. Best/Worst grades display per exam day.

Read More

SQL Challenge #6 – Locking locks your SQL Server

by | 2025-03-03 | Level 400, SQL Challenges | 3 Comments

A customer must run an INDEX Rebuild on a dedicated table every hour. What is the root cause for this behavior. Can you help?

Read More

SQL Challenge #5 – When Constraints not work

by | 2025-02-17 | Level 300, SQL Challenges | 8 Comments

Although a CHECK constraint limits the possible values, the query optimizer does not seem to take these limits into account. Why?

Read More

SQL Challenge #4 – Nightmares with User Defined Functions

by | 2025-02-09 | Level 300, SQL Challenges, Uncategorized | 4 Comments

Problem Description / Requirement The customer has developed an application that he himself has developed and swears by the use of user-defined functions. The developers argue that user-defined functions create reusable code that makes work easier. A calculated...
Read More

SQL Challenge #3 – Case Sensitive Searches

by | 2025-02-02 | Level 200, SQL Challenges | 9 Comments

Problem Description / Requirement The software manufacturer's database uses the [SQL_Latin1_General_CP1_CI_AS] collation for the application. The development team wrote a custom function that can be used to find customers based on an address search. The department had...
Read More

SQL Challenge #2 – Aggregations in Partitioned Tables

by | 2025-01-27 | Level 400, SQL Challenges | 4 Comments

SQL-Challenge #2 – Aggregations in partitioned tables

Read More

SQL Challenge #1 – When the marketing department calls

by | 2025-01-20 | Level 200, SQL Challenges | 9 Comments

SQL-Challenge #1 – When the marketing department calls

Read More