Now exactly which proposal is this
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,343 reads
Introduction
Oft times we are forced into situations where we clearly need to think outside of the box. A case at...
2016-03-10 (first published: 2016-03-01)
1,343 reads
This event promises to be a highlight of the Canadian SQL Server calendar year.
The presenters are all 'first class'.
All...
2014-05-27
804 reads
<p>Hi All This is a note that I just sent out. I hope that this helps those contemplating upgrading to...
2014-03-24
1,087 reads
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,149 reads
Introduction
The consumers of our data wish to be able to make stock and financial decisions from our data. Turning raw...
2014-02-02
1,788 reads
Introduction
In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data. Today...
2014-02-01
1,889 reads
Introduction
In the first part of this discussion, I discussed step by step instructions pertaining to getting up and running with...
2014-01-29 (first published: 2014-01-27)
5,204 reads
Introduction
In yesterday’s discussion we looked at populating entities and their related attributes. In today’s discussion we shall be concentrating on...
2014-01-29
2,088 reads
Introduction
About 12 months ago, I started to look at Master Data Services in a serious manner. I had toyed with...
2014-01-26
5,279 reads
Introduction
While Master Data Services is the best tool to come along to permit user to update their qualitative and quantitative...
2014-01-25
3,569 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