Skip to content
December 3, 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 Event Free Live Training Virtual Symposium DPD banglore
  • Free Courses
  • 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
    • Premium Content (SQLMaestros)
    • 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 by Amit Bansal (AB)
  • About Us
    • Subscribe To Our Newsletter
    • Social Channels
    • 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

Looking for Premium SQL Content?
Check out advanced SQL tutorials
on SQLMaestros


Subscribe to SQLServerGeeks

Free Live Event


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.