Skip to content
June 26, 2022
  • 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
  • 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: SQL Server indexes

SQL Server

sql_server_covering_index_2: Adding Non Key Columns

August 28, 2012November 5, 2015 - by Prince Rastogi - 2 Comments.

Hi Friends, This blog is the continuation of my previous blog on Use of Covering Indexes here is the link… Today here I will explain Adding non key columns in the …

sql_server_covering_index_2: Adding Non Key Columns Read More
SQL Server

SQL Server Covering Index 1

August 14, 2012September 15, 2014 - by Prince Rastogi - 2 Comments.

Hi Friends, Today, here I just want to explain ‘what is SQL Server Covering Index?’ as well as ‘why we use Covering Indexes?’ What is Covering Index? “Covering Index is a …

SQL Server Covering Index 1 Read More
SQL Server

SQL Server – Does an Index B-Tree structure always have a root page?

December 12, 2011September 30, 2014 - by Amit Bansal - 10 Comments.

Hi Friends, This is a common question I face in many of my classes and consulting assignments? The answer is NO. Indexes are B-Tree structures (balanced tree) where navigation/searching happens from …

SQL Server – Does an Index B-Tree structure always have a root page? Read More
SQL Server

SQL Server: Indexing for Aggregates in SQL Server

August 9, 2011September 30, 2014 - by Amit Bansal - 10 Comments.

Hi Friends, Here is a query and I want to create the right indexes for it. Let us do things step by step: (I am using AdventureWorks2008 for this) SELECT SOH.CustomerID, …

SQL Server: Indexing for Aggregates in SQL Server Read More
SQL Server

SQL Server Filtered Indexes

July 18, 2011November 14, 2014 - by Amit Bansal - 3 Comments.

Hi Friends, SQL Server Filtered indexes use a filter predicate to index a portion of the table, a well-defined subset of data. They can be considered to be an optimized alternative …

SQL Server Filtered Indexes 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

Subscribe To Our Newsletter

loader

Virtual Symposium

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