Optimize and Tune Queries

Practice Labs Module
Time
50 minutes
Difficulty
Intermediate

The "Optimize & Tune Queries" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Tuning Queries, 2) Use Recursive CTE, 3) Implement Full Text Search and Use Hints to Control Execution Plans.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Optimize & Tune Queries module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Tuning Queries
  2. Use Recursive CTE
  3. Implement Full Text Search and Use Hints to Control Execution Plans

Exercise 1- Tuning Queries

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Demonstrate tuning a badly performing query using execution plans
  • Tune a query workload using the database tuning advisor (DTA)

Exercise 2 – Use Recursive CTE

In this exercise, you will use recursive CTE in queries. A recursive common table expression (CTE) repeats the execution of the initial CTE and returns subsets of data until the final result set is obtained.

Exercise 3 – Implement Full Text Search and Use Hints to Control Execution Plans

In this exercise, you will create queries using full text search. You will then use query hints to control execution plans.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.