sql server execution plan operators

One Operator a Day

1_sql server execution plan operators

 

 

 

 

 

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!


 

OPTIMIZE FOR query hint in SQL Server

Hi Geeks, Many of us might have experienced that a query runs perfect for long time then suddenly it started performing very bad with no clues. After lot of investigation, we …

Read More »


SQL Server plan guide and execution plan

Hi Geeks, Think of a situation when you want to apply query hint to a query that is part of application code but development team is unwilling to touch application code. …

Read More »


SQL Server expand views hint and execution plan

Hi Geeks, Today I will be talking about SQL Server expand views hint and its impact on execution plan. We will create an indexed view first then dive into the topic. --USE …

Read More »


SQL Server query hints execution plan – Part3

Hi Geeks, Welcome to the Part3 of SQL Server query hints execution plan. You can read last two posts by clicking Part1 and Part2. Today we are going to see how …

Read More »


SQL Server query hints execution plan – Part2

Hi Friends, Welcome to the Part2 of SQL Server query hints execution plan and you can read Part1 by clicking here. Let us start with a simple query. In the example below …

Read More »


SQL Server query hints execution plan - Part1

Hi Friends, Today we are going to discuss on SQL Server query hints execution plan. Let us consider following SQL statement; USE [AdventureWorks2012] SELECT * FROM Sales.SalesOrderDetail ORDER BY SalesOrderDetail.ProductID Imagine …

Read More »


SQL Server table hints execution plan

Hi Geeks, Today we are going to explore SQL Server table hints execution plan operation. Consider following SQL query. USE [AdventureWorks2012]; SELECT * FROM Sales.SalesOrderDetail WHERE SalesOrderDetail.ProductID = 776 In the …

Read More »


SQL Server Join hints execution plan

Hi Friends, We can control SQL Server query optimizer’s decision by forcing any T-SQL queries to use a specific join type. In today’s post we will explore SQL Server Join hints …

Read More »


SQL Server Parallelism Operator

Hi Geeks, Today we will talk about SQL Server Parallelism Operator. SQL Server may decide parallelism to help some expensive queries to run faster which means it decides to use multiple …

Read More »


SQL Server Nested Loop Join Operator - Revisiting: Part2

Hi Geeks, Before moving ahead with something new on One operator a day series, I wanted discuss another scenario on SQL Server Nested Loop Join Operator. I recommend you to read my earlier …

Read More »


SQL Server Nested Loop Join Operator - Revisiting: Part1

Hi Friends, This is a follow up post of my previous blog posts on SQL Server Nested Loop Join operator Part1 and Part2. I got a question in one of the …

Read More »


SQL Server Cursor Operators – Part8

Hi Geeks, Today we will have a look into execution plan for READ_ONLY cursor. You can read my previous posts on SQL Server Cursor Operators by clicking Part1, Part2, Part3, Part4, Part5, …

Read More »


SQL Server Cursor Operators – Part7

Hi Geeks, Yesterday on Part6 of SQL Server Cursor Operators we saw how estimated execution plan changes when we change CURSOR type to KEYSET and today we are going to explore its …

Read More »


SQL Server Cursor Operators – Part6

Hi Geeks, Today we are going to discuss about KEYSET cursor and if you missed out earlier posts on SQL Server Cursor operators, you can click Part1, Part2, Part3, Part4 and …

Read More »


SQL Server Cursor Operators – Part5

Hi Geeks, I hope you liked Part1 , Part2 , Part3  and Part4 of SQL Server Cursor Operators. Today, we are going to see physical operators for a STATIC CURSOR. Let me use the same query …

Read More »


SQL Server Cursor Operators – Part4

Hi Geeks, Welcome to the Part4 of SQL Server Cursor Operators. You can read previous posts by clicking Part1, Part2  and Part3. In our previous posts, we have covered dynamic cursor operation but …

Read More »


SQL Server Cursor Operators – Part3

Hi Geeks, Welcome to the Part3 of SQL Server Cursor Operator. If you missed my last two posts on the subject you can read them by clicking Part1 and Part2. You might …

Read More »


SQL Server Cursor Operators – Part2

Hi Friends, Yesterday we have covered first part of the execution plan used in our example and in case you missed that, please click on SQL Server Cursor Operators – Part1 and …

Read More »


SQL Server Cursor Operators – Part1

Hi Friends, Today we are going to start on SQL Server cursor operators and continue our discussion for next few days. Let us consider following CURSOR which is declared with no options …

Read More »


SQL Server Eager Spool operator – Part2

Hi Geeks, I hope you liked Part1  of SQL Server Eager Spool operator. To start from where we left yesterday, today we are going to explore what happens if SQL Server …

Read More »


Older Entries »

Leave a Reply

Your email address will not be published. Required fields are marked *