In the previous article, you learnt about concepts of execution plan, operators, and their properties. In this article, you will learn about reading an execution plan.
[More]
When a query performs poorly and you fails to understand the reason behind it. You need to check the execution plan. However, reading an execution plan is like reading a new language. You need to understand the operators, their properties, data flows, meaning of icons, order of operators etc. In this article series, I am going to discuss this step by step.
[More]
That day one of my junior colleague rushed to me and sought my assistance. He failed to drop an user. It showed - "The database principal owns a schema in the database, and cannot be dropped." I took him to our office kitchen, had tea, and explained the issue.
[More]
At early stage of my career, SQL Server Database was like a black box to me. I submitted data a
[More]