Skip to content
Erik Darling Data
SQL Server Consulting, Education, and Training
  • Home
  • About Me
  • Coaching
  • Blog
  • Contact Me
  • FAQ

Category: columnstore

No Column Store Indexes With In-Memory Tempdb? No Problem!

November 19, 2019 Erik Darling Leave a comment

Old Habits Let’s say you’re on SQL Server 2019. No, seriously. It’s been out for a couple weeks now. You…

Continue Reading →

Posted in: columnstore, Query Tuning, SQL Server, tempdb

Stack Overflow Demo Database Column Store Edition: Helpful Links

November 15, 2019 Erik Darling Leave a comment

Sniff If you’re starting from scratch with column store, here are some links that’ll help you get a better understanding…

Continue Reading →

Posted in: columnstore, SQL Server, Stack Column Store

Stack Overflow Demo Database Column Store Edition: Exploring Relationships

November 14, 2019 Erik Darling Leave a comment

Special Relativity To get you started exploring the Stack Overflow column store database, here are some queries that show how…

Continue Reading →

Posted in: columnstore, SQL Server, Stack Column Store

A Bug With OBJECTPROPERTYEX And Column Store Indexes

September 16, 2019 Erik Darling Leave a comment

No, Not That Bug There’s a known bug with partitioned tables, but this is different. This one is with rows…

Continue Reading →

Posted in: columnstore, SQL Server

Columnstore Precon Details

September 3, 2019 Joe Obbish Leave a comment

I thought it could be helpful to go into more detail for what I plan to present at the columnstore…

Continue Reading →

Posted in: columnstore, SQL Saturday, SQL Server

CHECKDB Bug With SQL Server 2017 And ColumnStore Indexes

May 31, 2019 Erik Darling Leave a comment

Continue Reading →

Posted in: Bugs, CHECKDB, columnstore, SQL Server

Breaking Columnstore Delta Rowgroups

May 14, 2019 Joe Obbish 1 Comment

The documentation on delta rowgroups says: A delta rowgroup is a clustered index that’s used only with columnstore indexes. It…

Continue Reading →

Posted in: columnstore, SQL Server

Recent Posts

  • Waiting For Deadlocks
  • SQL Server 2019 Memory Grants Are Higher
  • Greatest, Least, and SQL Server

Categories

  • Accelerated Database Recovery
  • Batch Mode
  • Bugs
  • CHECKDB
  • columnstore
  • Dynamic SQL
  • Execution Plans
  • FROID
  • Indexing
  • Isolation Levels
  • Joe Obbish
  • Locking
  • Memory Grants
  • Office Hours
  • OPTIMIZE_FOR_SEQUENTIAL_KEY
  • Parallelism
  • Parameter Sniffing
  • perfview
  • Plan Cache
  • Query Tuning
  • Server Tuning
  • Spills
  • SQL Saturday
  • SQL Server
  • SQLBits
  • Stack Column Store
  • Statistics
  • tempdb
  • Training
  • Triggers
  • Wait Stats
Copyright © 2019 Erik Darling Data