Indexing

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 (1)

2020-09-16

2,338 reads

“Included columns” for non-clustered indexes explained

  • Article

Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]

4.17 (6)

2019-09-17

7,962 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

trigger email alerts in case file is delivered or failed for the job

By christi1711

Hi all, I have two SQL jobs. These jobs execute SSIS packages and then...

SQL Server maximum Server Memory

By IT researcher

I am using SQL Server 2008 R2  Express  edition. I have already set Maximum...

Developer vs Enterprise

By VastSQL

Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers