Installing Microsoft Hyper-V 2012 on VMware ESXi 5.1
For a weekend project, I’m installing Hyper-V 2012 in my home lab. I was having troubles getting Hyper-V installed on...
2013-07-06
881 reads
For a weekend project, I’m installing Hyper-V 2012 in my home lab. I was having troubles getting Hyper-V installed on...
2013-07-06
881 reads
What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world....
2013-06-26
1,350 reads
Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start...
2013-06-26
742 reads
A while back I wrote a blog post at the House of Brick technical blog that details talking points and...
2013-06-03
703 reads
WOW! I have not received the official confirmation yet, but last night John Troyer posted a new entry on the...
2013-05-29
764 reads
WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can...
2013-05-23
561 reads
This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA....
2013-05-21
496 reads
A while back Kendal Van Dyke (b | l | t) asked me a great question regarding the ideal VMware vSphere networking...
2013-05-16
1,508 reads
WOW! SQL Saturday Atlanta this year is turning into one of the largest SQL Saturdays ever! I’m absolutely honored and pumped to...
2013-05-03
650 reads
Yesterday I had the opportunity to speak at the first ever SQL Saturday Fargo! Jason Strate (b | l | t) and...
2013-04-28
779 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