Dot Net Usergroup in Montreal Presentation notes - Grouping Sets in SQL Server 2008
Yesterday evening I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original front-page blog post...
2009-03-13
642 reads
Yesterday evening I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original front-page blog post...
2009-03-13
642 reads
Last night I was at the store with Delaney after karate and he mentioned that we needed to go pick...
2009-03-13
856 reads
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of...
2009-03-13
840 reads
Last week I was in Seattle, so I decided to stay an extra day and drive up to Vancouver to...
2009-03-12
633 reads
I've always told DBAs and developers working for me that backups don't really matter. After all, 99.99% of the time...
2009-03-12
441 reads
Hi everyone, just little info that we have available the Service Pack 1 for SQL Server2008!
About overview, instructions, system...
2009-03-12
538 reads
Database Snapshots Can Take a Long Time to Create
Believe it, it's true!! One of the big selling point for database...
2009-03-11
4,794 reads
It's funny how life often gives us the buy or fix decision on some many things, and the hard part...
2009-03-11
580 reads
We’re on Twitter as @SQLServerCentrl. We couldn’t fit the whole name in there given the limitations of Twitter, but feel...
2009-03-11
363 reads
What do MVPs get to do and see at the MVP Summit? Well most of it is under NDA, so...
2009-03-11
475 reads
I recently had to copy an Azure SQL database (SQL db) from one subscription...
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation
Hi i was surprised to see the approach my coworkers used to sunset talend...
The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?
See possible answers