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]
That day, I was purchasing some items from my neighbouring grocery shop. I noticed, the shop owner was maintaining his debtors list in his ledger book. I found his ledger book started with a table of his customer list along with page numbers. Pages had transactions of individual customer. In case of a page became full, it had reference of another pages with bunch of transactions. There are some blank pages and also blank spaces in some pages. Suddenly, I realized how SQL Server manage the INDEX functionality.
[More]
Today, I am going to explain you Clustered Columnstore Index and some related concepts. As a Database enthusiastic, you should know it.
[More]
Last week, I was discussing with one of my junior colleagues. He needed to add thousands phone numbers from a web form to database. He was looking for an efficient way.
[More]
Today I am going to show you how to import data from a CSV file using Transact-SQL BULK INSERT and the OPENROWSET(BULK...) statement.
[More]
I shared my 17 years experience with the audience what they should know about MSSQL Server.
[More]
Now I am a
Microsoft Certified: Azure Database Administrator Associate
check out my badge.
[More]