Skip to content
March 6, 2021
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training   Data Platform Virtual Summit 2020   Virtual Symposium   DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Events
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra
    • Virtual Symposium Recordings
    • Geek Talks
  • PodCasts
  • Conference
  • Resources
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
    • Connect With Amit Bansal
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
Main Menu

Author: Kanchan Bhattacharyya

SQL Server

SQL Server Execution Plan (One Operator a Day) Index

July 20, 2015 - by Kanchan Bhattacharyya - 1 Comment

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 More
SQL Server

Auto parameterization in SQL Server

December 5, 2014November 30, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Dear 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 More
SQL Server

SQL Server optimize for unknown and local variables

December 2, 2014November 29, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Hi 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 More
SQL Server

Parameter sniffing in SQL Server

November 29, 2014November 29, 2014 - by Kanchan Bhattacharyya - 1 Comment

Hi 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 More
SQL Server

SQL Server narrow plans (per-row)

November 26, 2014November 26, 2014 - by Kanchan Bhattacharyya - Leave a Comment

Hi 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 More
One Operator a Day / SQL Server

OPTIMIZE FOR query hint in SQL Server

November 20, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

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
One Operator a Day / SQL Server

SQL Server plan guide and execution plan

November 19, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

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
One Operator a Day / SQL Server

SQL Server expand views hint and execution plan

November 18, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

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
One Operator a Day / SQL Server

SQL Server query hints execution plan – Part3

November 17, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

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
One Operator a Day / SQL Server

SQL Server query hints execution plan – Part2

November 16, 2014July 3, 2020 - by Kanchan Bhattacharyya - Leave a Comment

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

Posts navigation

1 2 … 11 Next

Subscribe to SQLServerGeeks

Ad

master classes

SSG_linkedin

SSG_fb

dps2017_logo_website

video courses

dps2017_logo_website

create your blog

guest_post

DataPlatformGeeks Social Media Channels

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Subscribe To Our Newsletter

loader

Copyright © 2019 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by SQLServerGeeks and DataPlatformGeeks.