Query Execution Plans

preview_player
Показать описание
SQL Server Unlocked Series- Query Execution Plans

In this video, we will be discussing query execution plans and how to use them properly.

In this video, Morelan starts out with an analogy relating SQL Server to your kid. I know this sounds pretty far-fetched, but he has a point, so give it a chance. He goes on to describe how you want SQL Server to perform to the best of its ability, same as you would want your kids to do, hence why we use query execution plans.

Additionally, If you lose something such as your keys, you probably want a tool that shows you how to find that item, if you set up your SQL server right, this is just the tool- not to find the keys but to find data.

All-in-all SQL server can save you time if you use it right and you know how to use it right. This mini-series is a good starter on how to do so. Have a look at the video, and if you want to learn more, take our class Developer 2012 Volume 3 Video 9.1.

Рекомендации по теме
Комментарии
Автор

I really appreciate you taking the time to cover this very important topic regarding query optimization. I am a member of Joes2Pros Academy and highly recommend it to any IT professional wanting to become the best they can be in their field of expertise. Looking forward to seeing more on this particular topic - thank you!

GayleHallAZ
Автор

real life example makes it easier to understand ..nice work

Merajmohdkhan
Автор

Who does this boy tells? Why does he is looking to that guy but not to camera?
Stuppid course. Switch the "instructor" to became better

tamito