SQL SERVER – Getting Started with Execution Plans

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.

SQL SERVER - Getting Started with Execution Plans executionplans

SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan

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.

SQL SERVER – Execution Plan Ignores Tabs, Spaces, and Comments

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.

SQL SERVER – Puzzle – Why Such a Complicated Execution Plan for a Single Row, Single Table Query?

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)

Execution Plan
Previous Post
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Next Post
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script

Related Posts

28 Comments. Leave new

  • On 12th oct, 2011 I have gone to kolkatta from Agartala by Spicejet 874. We have reached to kolkatta at perfect time. The air hosstresses are so helpfull. They are talking with the passangers in very sweet and low voice. I am impressed on the cabin crew and I want to go again and again by this flight.

    Reply
  • it was great experience by Spicejet.>>> i am not at all agreed by your comments…

    Reply
    • most importantly characters of many spicejet pilots are not good.one of my colleague knew one spicejet pilot,Mr Vaibhav Sharma,1st officer of the same airlines,character wise that man was nothing but a male prostitute.he insisted boarders specially night time international boarders to make physical relationship with him.if they are not willing to do it,that man became very abusive.i think this type of person is unfit for this responsible job.he must be kicked out from the job.

      Reply
      • Vaibhav Sharma
        July 16, 2015 2:13 pm

        Dear Simran,

        Next time you try to defame someone, google about the profession, the industry and correct terminology. The above mentioned pilot is aware of this fake profile and complaint, and will soon file a complaint against you under section 499 of IPC.

Leave a Reply