One Operator a Day
Hi SQL folks, my name is Kanchan Bhattacharyya. I work as a Sr. DBA in a leading IT services company. In this “One Operator a Day” series, I intend to write about SQL Server Execution Plan Operators. Hope you enjoy! Happy Learning!
Assert operator SQL Server - Part1
Hi Geeks, An assert operator SQL Server appears in query plan when there is a need to verify a value, commonly constraints like CHECK or FOREIGN KEYs however other scenarios are …
Read More »
SQL Server Concatenation Operator – Part3
Hi Friends, This is the third part on SQL Server Concatenation operator and if you missed my earlier posts, you can read Part1 and Part2 to understand the background of this blog post. …
Read More »
SQL Server Concatenation Operator - Part2
Hi Friends, Yesterday we have covered some basic points which will help us to understand SQL Server Concatenation operator. If you have missed that post, you can click here to go to …
Read More »
SQL Server Concatenation Operator – Part1
Hi Geeks, SQL Server concatenation operator receives one or more inputs and returns all the rows from each input stream. In general we can see this in action while using UNION …
Read More »
SQL Server Compute Scalar Operator – Part2
Hi Geeks, Today we are going to see an interesting behaviour of SQL Server compute scalar operator SQL 2005 onwards. I recommend you to read Part1 before reading this post. Consider following …
Read More »
SQL Server Compute Scalar Operator – Part1
Dear Friends, SQL Server compute scalar operator performs a scalar computation and returns computed value. This calculation can be as simple as conversion of value or could be concatenation of value. …
Read More »
SQL Server aggregate operator - Stream Aggregate Part3
Hi Friends, I hope you liked previous blog posts on SQL Server aggregate operator – Stream Aggregate Part1 and Part2. In today’s post, we are going to see that this operator can also …
Read More »
SQL Server aggregate operator - Stream Aggregate Part2
Hi Geeks, I hope you liked yesterday’s blog post on SQL Server Aggregate operator – Stream Aggregate Part1. Today, let us see what happens when we execute any query statement(s) using …
Read More »
SQL Server aggregate operator - Stream Aggregate Part1
Hi Friends, Today, we will have a look into SQL Server aggregate operator – Stream Aggregate. This operator used to group some rows by one or more columns and to calculate …
Read More »
SQL Server Sort Operator – Part2
Hi Geeks, Continuing from my yesterday’s blog post on SQL Server sort operator part1 , let me modify our query little bit as following then see what impact it has on …
Read More »
SQL Server Sort Operator – Part1
Hi Friends, When we add some basic clauses to a query statement, different operators start appearing on the execution plan and today we are going to discuss SQL Server Sort operator …
Read More »
SQL Server RID Lookup Operator
Hi Geeks, Non-clustered indexes can exist both on heaps as well as objects with clustered indexes and it is possible to have a key lookup on a heap.It is reflected in …
Read More »
SQL Server Key Lookup Operator - Part 4
Hi Geeks, Last three days we have been discussing on SQL Server Key Lookup operators and if you are reading this post ahead of them, I recommend you to read Part1 , …
Read More »
SQL Server Key Lookup Operator – Part 3
Dear Friends, I hope you liked my last two blog posts Part1 and Part2 on sql server key lookup operator. Starting from where we stopped yesterday, let us modify StateProvinceID to 79 in our …
Read More »
SQL Server Key Lookup Operator – Part 2
Hi Geeks, I hope you liked yesterday’s post SQL Server Key Lookup operator Part1. Today, we are going to decode query plan in text and xml then find out if this operator appears anything different …
Read More »
SQL Server Key Lookup Operator– Part 1
Hi Friends, Continuing from yesterday’s post on Non-clustered Index seek operation, obvious question is what happens if non clustered index does not contain all columns requested by statement(s)? To find an …
Read More »
SQL Server Index Seek Nonclustered
Hi Geeks, SQL Server index seek nonclustered uses a non-clustered index to perform search operation. The statement below illustrate a non-clustered index seek operator. USE [AdventureWorks2012] SELECT Address.AddressID, Address.StateProvinceID FROM Person.Address …
Read More »
SQL Server Clustered index scan vs Clustered index seek
Dear Friends, Yesterday and day before we have covered Clustered Index Seek and Clustered index Scan. In today’s post, let us draw a comparison between SQL Server clustered index scan vs clustered …
Read More »
SQL Server Clustered Index Seek Operator
Hi Friends, Let us look at Clustered Index Seek operator today. The statement below shows an example of SQL Server Index Seek (clustered) and of course database is our dearest AdventureWorks2012. SELECT …
Read More »
SQL Server Clustered Index Scan Operator
Hi Geeks, In this blog post we will explore on SQL Server Clustered Index Scan operator then try to understand different reason for which SQL Server optimizer picks up this to …
Read More »