Performance and Tuning

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

3,084 reads

Blogs

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

First Time Speaking with a Mask at an Event

By

Over the past couple of months, I have started losing my ability to talk...

A New Word: Apolytus

By

apolytus– n. the moment you realize you are changing as a person, finally outgrowing...

Read the latest Blogs

Forums

Disk (SCSI) Controllers - Parallel Disk I/O

By lanky_doodle

Hey For SQL Server VMs I use the max number of SCSI controllers supported...

SQL Server Semantic Search (Find Text in External Files)

By Stephen Butland

Dear community, I am trying to search word documents (docx) for a particular drug...

Data Archival: 1 table (Database A) to 1 table (Database B)

By Tava

I'm currently in the process of building an archival  & reporting solution and just...

Visit the forum

Question of the Day

Read Only Replica in SQL Server Standard

Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?

See possible answers