SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Register your product to gain access to bonus material or receive a coupon.
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.
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.