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,054 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,237 reads
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
Comments posted to this topic are about the item New Stuff Can Be Scary
Hi everyone, Working with a stored procedure that is used in an application of...
Hi All, Has anyone got any tips for sizing a move from VM running...
Ask SSC