70-461 Lessons

36 Articles

Understanding Plan Iterators

Last Updated On : Tuesday, May 22, 2018As you already know from Chapter, SQL Server executes a query by using a set of physical  operators. Because these operators iterate through rowsets, they are also called iterators. In this lesson, you learn details about some of the most important iterators: those used to access data, perform […]

Using Dynamic Management Objects

Last Updated On : Tuesday, May 22, 2018Even with Extended Events, SQL Trace, SQL Server Profiler, SET session options, and the execution plans of the SQL Server toolset to help you, the options for optimizing your queries are still not exhausted. SQL Server constantly monitors itself and gathers information useful for monitoring the health of […]