Missing Index

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)

You rated this post out of 5. Change rating

2021-07-07

2,904 reads

Blogs

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Read the latest Blogs

Forums

SQL AOAG with listener ( without windows clustering)

By chetan06

Hello, I am deploying SQL 2019 Enterprise edition with AOAG ( without windows clustering)....

Event ID 65102 [Warning] FailoverClusterQueryError

By Luckless7611

Hello @all, i am facing a problem and can not find a solution... I...

Check scheduled pipelines in ADF

By blom0344

We are used to the job activity monitor in SQL server allowing quick checks...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers