Erin Stellato

Erin Stellato is a Senior 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.

Sparse Columns in SQL Server : Impact on Time & Space

Posted by Erin Stellato on February 5, 2016 No Responses »

Feb 052016

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.

Capture Execution Plan Warnings using Extended Events

Posted by Erin Stellato on October 27, 2015 3 Responses »

Oct 272015

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.

Proactive SQL Server Health Checks, Part 5 : Wait Statistics

Posted by Erin Stellato on October 1, 2015 1 Response »

Oct 012015

Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.

Proactive SQL Server Health Checks, Part 4 : ERRORLOG

Posted by Erin Stellato on July 30, 2015 5 Responses »

Jul 302015

Erin Stellato (@erinstellato) describes the value of the SQL Server error log in her ongoing series about proactive health checks.

Incremental Statistics are NOT used by the Query Optimizer

Posted by Erin Stellato on May 19, 2015 8 Responses »

May 192015

Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.

Improving Partition Maintenance with Incremental Statistics

Posted by Erin Stellato on May 13, 2015 2 Responses »

May 132015

Erin Stellato (@erinstellato) demonstrates the benefits of incremental statistics in SQL Server 2014, and also outlines some unexpected behavior.

Proactive SQL Server Health Checks, Part 3 : Instance and Database Settings

Posted by Erin Stellato on February 12, 2015 No Responses »

Feb 122015

Erin Stellato (@erinstellato) adds another entry to her series on proactive health checks for SQL Server, this time treating database and instance settings.

1 2 3 4