“Included columns” for non-clustered indexes explained
Learn about the advantages and disadvantages of using INCLUDE columns in your index.
2021-04-30 (first published: 2019-09-17)
18,349 reads
Learn about the advantages and disadvantages of using INCLUDE columns in your index.
2021-04-30 (first published: 2019-09-17)
18,349 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,947 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
By Steve Jones
Today’s coping tip is to be gentle with yourself when you make mistakes. I...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...