Skip to content
January 30, 2023
  • 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 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
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: index seek

SQL Server

Column order and equality operator on Index

September 10, 2016October 26, 2016 - by Sandip Pani - Leave a Comment

Does Column order  in where clause matters? Whenever I have any doubt, I always play around with it to clarify my doubt. While doing experiment with index operation, I learnt something …

Column order and equality operator on Index Read More
SQL Server

Index Selection Fundamental

July 30, 2016October 26, 2016 - by Sandip Pani - Leave a Comment

Index is one of most widely discussed topic among developers and DBAs. During query optimization Index is one of the important aspects. I came across multiple instances where Developer/ DBA creates …

Index Selection Fundamental Read More
SQL Server

Clustered Index seek doesn’t guarantee optimal Query plan

June 16, 2016November 11, 2016 - by Sandip Pani - Leave a Comment

I was working on removing duplicate indexes from a table. Before removing an index usually I check whether that index is used by any query or not, is there any index …

Clustered Index seek doesn’t guarantee optimal Query plan Read More
SQL Server / SQL Server Accidental DBA Series

Index seek vs Index scan in SQL Server

November 5, 2014December 23, 2019 - by SQL Geek - Leave a Comment

An index is a way to speed up performance of a query in SQL Server. An index is a B-Tree structure on a table column or set of columns referred as …

Index seek vs Index scan in SQL Server Read More
SQL Server

SQL Server impact of different collation and query plan

February 9, 2014September 21, 2014 - by Kanchan Bhattacharyya - 1 Comment

Hi Friends, Recently I completed my blog series on execution plans which I hope helped you to understand on the basics. Couple of days back, I got a message in one …

SQL Server impact of different collation and query plan Read More
SQL Server

SQL Server Index Internals Part 2 – Why is the Optimizer SEEKING instead of SCANNING

March 29, 2012September 30, 2014 - by Amit Bansal - 5 Comments.

Hi Friends, I had started the SQL Server index internal series sometime back. The first part is here; Apologies for making it late on Part 2 – this part is more …

SQL Server Index Internals Part 2 – Why is the Optimizer SEEKING instead of SCANNING Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

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

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.