Dennes Torres in Blogs

SQL Server 2022: How Auto-Drop Statistics Work

Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table...

Making Data Analytics Simpler: SQL Server and R

R and SQL Server are a match made in heaven. You don't need anything special to get started beyond the...

So far in this series we’ve talked about interpreting the shape of an execution plan and understanding the meaning of...

Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into...

Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but...

Kat Hicks

When a database starts showing signs of an illness, it's up to the DBA to get to the root of...

SQL Server's Query Optimiser relies on statistics for providing a decent query plan. If the statistics are wrong, outdated or...

Robert Young in Learn SQL Server

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw...

Fabiano was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current...

SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common...