Execution Plans is one of the most interesting subjects and I often get a question about it. Many people want to know how to get started with the execution plans and this blog post is briefly discussing the same subject. As a part of removing the older blog posts which are no longer relevant, I am updating this blog post with the new content about it.
Traveling can be the most interesting or most exhausting experience. However, traveling is always the most enlightening experience one can have. While going to a long journey one has to prepare a lot of things. Pack necessary travel gears, clothes, and medicines. However, the most essential part of travel is the journey to the destination. There are many variations one prefer but the ultimate goal is to have a delightful experience during the journey. Let us learn about Performance Tuning with Execution Plans.
Just another day I was delivering my training SQL Server Performance Tuning Practical Workshop, I noticed that organizations had many stored procedures but none of the SP had any comments. When I asked them why their Stored Procedures does not have comments, their point was that they believed because of the comments, the size of the execution plan increases. Not True, when SQL Server builds an execution plan, it ignores tabs, spaces, and all the comments.
It has been awhile since I asked any puzzle on SQLAuthority.com, Let us see a very simple puzzle today which involves execution plan as well. To simulate the puzzle, you will need to install WideWorldImporters sample database in your system. You can find the complete instructions to install sample database over SQL SERVER 2016 – How to Import New Sample Database WideWorldImporters.
Reference: Pinal Dave (https://blog.sqlauthority.com)