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 MoreOne Operator a Day
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 MoreSQL 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 MoreSQL 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 MoreSQL 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 MoreSQL 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 MoreSQL 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 MoreSQL 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 MoreSQL 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 MoreSQL 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