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
6,472 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,191 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
I am working an exercise problem where the solution provided has a WHERE clause...
Hello, Is there any way to get the list of server administrators from SSAS...
We are running SQL Server 2012 SP4 Standard Edition on Windows Server 2012 R2...
Ask SSC