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 …
Read MoreSQL Server Education (by the geeks, for the geeks)
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 …
Read MoreDear Friends, Today we are going understand auto parameterization in SQL Server. In simple words SQL Server query optimizer may return the same plan in the cases where it doesn’t matter …
Read MoreHi Geeks, In my previous blog post we saw how parameter sniffing could negatively impact any query performance when SQL Server query optimizer decides to sniff parameters. There are different ways that …
Read MoreHi Friends, SQL Server uses histograms from statistics objects to estimate cardinality of a query and this helps SQL Server to produce an optimal execution plan. Query optimizer has to inspect …
Read MoreHi Friends, When we update any data which has to modify and update existing non-clustered index using per row is also known as SQL Server narrow plans. In per row operations …
Read MoreHi 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 MoreHi 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 MoreHi 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 MoreHi 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 MoreHi 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