SQL Server Advanced Query Tuning

Home/Development, SQL Server/SQL Server Advanced Query Tuning

SQL Server Advanced Query Tuning

$15.00 $4.00

This lab talks about a very common yet difficult problem, finding TOP n rows per group. The problem may seem easy, however in this lab we’ll discuss multiple ways to solve this problem and compare the different ways on performance to find out the fastest way to solve the problem. In the first exercise, we’ll talk about TOP use cases and in the second exercise we’ll talk about the Top n rows per group problem and it’s different solutions.

Exercise 1: Use Cases Of TOP
Exercise 2: Query Tuning Techniques

Categories: ,

Description

This lab talks about a very common yet difficult problem, finding TOP n rows per group. The problem may seem easy, however in this lab we’ll discuss multiple ways to solve this problem and compare the different ways on performance to find out the fastest way to solve the problem. In the first exercise, we’ll talk about TOP use cases and in the second exercise we’ll talk about the Top n rows per group problem and it’s different solutions.

Exercise 1: Use Cases Of TOP
Exercise 2: Query Tuning Techniques

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.