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
5,991 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,100 reads
By Gail Shaw
It’s a few days into April, but not too late I hope to mention...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Sometimes in life you have to do things you really don’t like to do....
I am proposing to the business that we use SQL 2019 Developer in our...
Hi, I have cluster SQL (2008) running under windows server 2008. The cluster is...
The cdc capture job ran into errors on our prod server. The error reporting...
Ask SSC