Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003, and has provided support for SQL Server environments across a variety of industries including healthcare, insurance, finance and government. Click here for a full bio.
Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017.
Erin Stellato (@erinstellato) takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.
Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.
Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.
