Submit Blog

Sign up Sign in

Search Articles

Filter by Tag

Sort By

Popular Tags

Logical Reads Articles

Page 1 of 1 (2 articles)

Database Animations: Why Big Columns May Not Affect Logical Reads

8/6/2026 • EN

Database Animations: Why Big Columns May Not Affect Logical Reads

Brent Ozar explains why wide columns in SQL Server tables may not increase logical reads, using database animations and sp_tableoption.

Database Performance indexing Logical Reads SQL Server T SQL

Logical Reads Aren’t Repeatable on Columnstore Indexes. (sigh)

3/10/2026 • EN

Logical Reads Aren’t Repeatable on Columnstore Indexes. (sigh)

Explains why logical reads are not repeatable when using columnstore indexes in SQL Server, challenging a common tuning assumption.

Columnstore Indexes Database Tuning Logical Reads Query Performance SQL Server