“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)
19,297 reads
Michael Salzmann
Comparing Space Usage for Different Compression Types
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
2,000 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
Swapping coordinate pairs round
So I'm using SQL Server 2014 and I've been using Jeff Moden's excellent string...
DOP_FEEDBACK in SQL MI
I'm changing the DB Compatibility mode to 2022 in SQL Managed Instance. below features...
index analysis help
Hi All, We see some tables in Prod are having 20-30 indexes and we...
Ask SSC