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

7,739 reads

Blogs

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

What is the CONTROL permission?

By

One of the most powerful permissions available in SQL Server is control. But what...

Daily Coping 19 Jan 2021

By

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

Read the latest Blogs

Forums

Get local server's alias in T-SQL

By schleep

Hello, I'm trying to get the server name programmatically. Even after I do this:...

Get local server's alias in T-SQL

By schleep

Hello, I'm trying to determine if there's a way to get a server's alias...

Issues with multiple SSAS tabular instances on same server

By rnguyen11

I have created a second instance of a tabular server on the same server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers