SQL Server - How to Think Like an Engine

RSS

Presented by: Brent Ozar Running Time: 64 min How does SQL Server decide how to execute a query? Microsoft Certified Master Brent Ozar will break things down from the start by explaining indexes, joins, sorting, statistics, and execution plans. He'll start by giving you a set of spreadsheets, and by the end of the session, you'll be building your own execution plans. You'll understand how to build your tables and make queries go faster.

Buy This On-Demand Training Now!

This video is part of the How to Think Like an Engine in SQL Server On Demand training.

How does SQL Server decide how to execute a query? Microsoft Certified Master Brent Ozar will break things down from the start by explaining indexes, joins, sorting, statistics, and execution plans. He'll start by giving you a set of spreadsheets, and by the end of the session, you'll be building your own execution plans. You'll understand how to build your tables and make queries go faster.

Already purchased this? to view your content.

From the Blogs
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×