Chapter 16. Understanding Cursors, Sets, and Temporary Tables

Exam objectives in this chapter:

  • Troubleshoot & Optimize

    • Evaluate the use of row-based operations vs. set-based operations.

This chapter covers two main topics. It starts with a lesson about the differences between row-by-row operations and set-based operations. It then continues with a lesson about the use of temporary objects like local temporary tables and table variables, explaining when you should consider using each kind.

Lessons in this chapter:

Before You Begin

To complete the lessons in this chapter, you must have:

  • Experience working with Microsoft ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.