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:
To complete the lessons in this chapter, you must have:
Experience working with Microsoft ...