Why Does SQL Server not have 200 buckets in the statistics histogram when there are >100k distinct values in the table

All we need is an easy explanation of the problem, so here it is. Given I am using the AdventureWorks2016 OLTP database why does the statistics histogram for the index…

Continue ReadingWhy Does SQL Server not have 200 buckets in the statistics histogram when there are >100k distinct values in the table

What are these SFP files that SQL Server distributes?

All we need is an easy explanation of the problem, so here it is. What are the SFP files that come with SQL Server 2017? /opt/mssql/lib/sqlservr.sfp /opt/mssql/lib/sqldkxplat.sfp /opt/mssql/lib/secforwarderxplat.sfp /opt/mssql/lib/system.common.sfp /opt/mssql/lib/system.certificates.sfp…

Continue ReadingWhat are these SFP files that SQL Server distributes?