Log in | Register

One Operator a Day Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education One Operator a Day Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

One Operator a Day

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

One SQL Server Execution Plan Operator a Day

SQL Server Execution Plan (One Operator a Day) Index

Dear Geeks,

Last Staurday, 18th July while interacting with attendees of SQL Server Day event held at Gurgaon and feedback from my friend Prince, I realized that I should publish a revised index of my series One Operator a day.

I published TOC for the same sometime back as per the advice of MSDN moderator Ronen […]

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 find that parameter that are supplied by application to run the respective SQL query performs well but sometime because of certain value the plan […]

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. Does this mean there is no way other than changes to code, the answer is NO. We can force a query to use a […]

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.

Now, let us run following SQL statement and see the execution plan.

Above plan uses indexed view instead of query. Now let us use EXPAND VIEWS hint then […]

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 we can control union operations in execution plan.

From above figures, though Concatenation operation (read here Part1, Part2, Part3) is cheap but Sort (read here […]

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 we have a GROUP BY clause that is used to display count of each City in Address table.

Default choice of the query optimizer to […]

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;

Imagine that our application is only concerned about First N rows at a time and similar execution plan shown in above figure can be an expensive one though it is chosen to be most appropriate […]

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.

In the example, Query optimizer estimates only few records to be returned and it decided to use an Index Seek and Key Lookup (read here Part1, Part2, Part3, Part4) combination in the query followed by Nested Loop Joins […]

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 and their impact on execution plans.

Let us begin with following sql query and see what the default choice of query optimizer is.

 

Hash Match join […]

SQL Server Execution Plan Index (TOC)

Hi Geeks,

It is always great to have links to the articles (especially for a series) in a page so that we could choose and refer them as per our requirement. On the same note  purpose of this blog post is to include links for all the articles that are published in One Operator a Day series.

I’ll keep modifying this […]

Newsletter_Footer