Data Governance Policy
What is a Data Governance Policy?
Data governance policy is concerned with how an organization collects, stores, accesses and maintains its...
2016-09-19
2,390 reads
What is a Data Governance Policy?
Data governance policy is concerned with how an organization collects, stores, accesses and maintains its...
2016-09-19
2,390 reads
Text Mining with RapidMiner for Loch Ness Monster Sightings
Text mining involves pulling root words from text in a system. In...
2016-02-11
474 reads
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
537 reads
Azure Data Catalog
Now available in public preview is the Azure Data Catalog. The Data catalog provides an enterprise data repository...
2015-09-08
651 reads
SQL Server 2016 Stretch Database
One of the features in SQL Server 2016 that you will want to explore is the...
2015-08-17
1,276 reads
Machine Learning Data Sets
When starting out with data mining and machine learning you will need to have access to sample...
2015-08-07 (first published: 2015-08-04)
2,874 reads
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data...
2015-07-20
1,304 reads
I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session...
2015-07-19
635 reads
Leveraging SQL Server Database Schema
Data warehouses typically pull data from various sources and combine the data into a common repository....
2015-06-24
668 reads
I am presenting the lunch keynote at the Toronto Chief Data Officer Summit on June 4th. My session is on...
2015-05-24
420 reads
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...
By Steve Jones
A friend was asking for help with some data analysis. This was in PowerBI,...
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