Indexing

SQLServerCentral Article

More on Column Choice and Order for Multi-column Non-Clustered Indexes

  • Article

In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]

4.5 (2)

2021-07-07

2,598 reads

SQLServerCentral Article

Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation

  • Article

Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]

5 (6)

2021-05-10

4,630 reads

SQLServerCentral Article

Indexes: When Column Selectivity Is Not Always A Requirement

  • Article

While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]

5 (6)

2023-01-02 (first published: )

4,828 reads

Blogs

Is Cataloging Your Data Important?

By

Data continues to be the lifeline for companies across the globe. As maturity levels...

Daily Coping 20 Mar 2023

By

Today’s coping tip is to get outside and notice how the weather feels. This...

Tales From The Field Weekly Wrap Up for the Week of 03-13-2023 & SQLBits 2023

By

 Hello Dear Reader!  What an incredible week we had.  I started off traveling on...

Read the latest Blogs

Forums

Azure SQL - Restore to lower enviornment

By PJ_SQL

Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...

Bcp queryout issue

By kakovatos7

Hi all, I am running the following query in SQL, trying to export some...

SQL Server RLS Database Users and Login User Permission

By Irakli Lomidze

Please suggest practice on SQL Server RLS On the database level, defined users with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers