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 […]
2019-09-17
7,739 reads
This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.
2017-03-23
1,387 reads
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
One of the most powerful permissions available in SQL Server is control. But what...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Hello, I'm trying to determine if there's a way to get a server's alias...
I have created a second instance of a tabular server on the same server...
Ask SSC