Michael Salzmann

“Included columns” for non-clustered indexes explained

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

5,991 reads

Blogs

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

Read the latest Blogs

Forums

Developer Edition

By Admingod

I am proposing to the business that we use SQL 2019 Developer in our...

SQL server agent stop working (the server threw an exception [0x80010105])

By TecMath

Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...

change data capture errors cdc_errors

By jaya

The cdc capture job ran into errors on our prod server. The error reporting...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers