70-461 Querying MS SQL Server2012 course

95 Articles

Understanding Further Optimization Aspects

Last Updated On : Wednesday, May 23, 2018Understanding Further Optimization Aspects Overview In Chapter , “Implementing Indexes and Statistics,” you learned internals about indexes and statistics in Microsoft SQL Server. In Chapter , “Using Tools to Analyze Query Performance,” you learned about the tools that help you analyze how a query was executed. In this […]

Understanding Cursors & Sets and Temporary Tables

Last Updated On : Wednesday, May 23, 2018Understanding Cursors & Sets and Temporary Tables Overview This chapter Understanding Cursors & Sets and Temporary Tables 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 […]

Implementing Indexes and Statistics

Last Updated On : Wednesday, May 23, 2018Implementing Indexes and Statistics Overview In Chapter , “Using Tools to Analyze Query Performance”, you learned about the tools that help you find performance problems. Indexes are mentioned in that chapter many times. This is not a coincidence. Proper indexing is necessary for good performance of your databases. […]

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 […]