Using Query and Table Hints in SQL Server

Home/Administration, Development, SQL Server/Using Query and Table Hints in SQL Server

Using Query and Table Hints in SQL Server

$4.00

Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They are better addressed by also analyzing the application queries and updates that the application submits to the database, and how these queries and updates interact with the data contained in the database and the database schema. In the first and second exercise of this lab, we will look into different query hints available in SQL Server. In the third exercise, we will look at table hints.

Exercise 1: Query Hints Part 1
Exercise 2: Query Hints Part 2
Exercise 3: Table Hints

Description

Many administrators address performance problems solely by tuning system-level server performance: for example, memory size, type of file system, number and type of processors, and so on. However, many performance problems cannot be resolved this way. They are better addressed by also analyzing the application queries and updates that the application submits to the database, and how these queries and updates interact with the data contained in the database and the database schema. In the first and second exercise of this lab, we will look into different query hints available in SQL Server. In the third exercise, we will look at table hints.

Exercise 1: Query Hints Part 1
Exercise 2: Query Hints Part 2
Exercise 3: Table Hints

Reviews

There are no reviews yet.

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

Content missing