Home > Store

Module 4: Troubleshoot and Optimize, Downloadable Version

Module 4: Troubleshoot and Optimize, Downloadable Version

Downloadable Video

  • Your Price: $33.99
  • List Price: $39.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2015
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-399572-0
  • ISBN-13: 978-0-13-399572-5

Module 4: Troubleshoot and Optimize

In this module, you will learn how to troubleshoot and optimize queries. We start first with understanding and using SQL Server’s built in objects for optimizing. We will then see how to understand and manage transactions and row-based operations. Finally, we will implement error handling procedures.

Lesson 14: Optimize Queries

In this lesson, you will learn how SQL Server implements and optimizes queries. We will read and analyze query plans, as well as use optimizer hints and plan guides.

Lesson 15: Manage Transactions

In this lesson, you will learn how to apply transaction commands for both implicit and explicit transactions. We will also examine locking protocols and transaction isolation levels.

Lesson 16: Evaluate the Use of Row-Based Operations vs. Set-Based Operations

In this lesson, you will learn how to implement row-based cursor commands. We will examine and compare the affect of using a cursor-based solution versus a set-based solution.

Lesson 17: Implement Error Handling

In this lesson, you will learn methods to catch and redirect errors during query execution. We will examine error handling with TRY and CATCH blocks, using THROW, and implementing XACT_ABORT.


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership