When people begin applying DevOps principles to database development using Redgate tooling, often one of the first steps in the process involves getting database code into version control. Questions...
2020-01-11
33 reads
Are we Human or Robots ? AI & ML shall definitely change the world some day in future. One thing is also sure, very soon we’ll also become machines...
2020-01-07
11 reads
I’ve learned a bit about Git in the last year: I’m now quite comfortable creating and managing Git Repos in Azure DevOps. I frequently do demos with SQL Change...
2020-01-03
6 reads
In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix...
2019-12-27
22 reads
In this six minute video, I explain why you should take the 2020 State of Database DevOps Survey. The survey is open for a few more days — we’ve...
2019-12-19
4 reads
I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before. In this 22 minute whiteboarding session, I talk about why we need...
2019-12-18
3 reads
ONLINE operations in SQL Server were simple to understand for years — we got ONLINE index rebuilds in SQL Server 2005. That was it for a while. Then, things...
2019-12-10
349 reads
The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the...
2019-12-09
5 reads
Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line. Spoilers: The command I show in...
2019-12-02
33 reads
I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video. I find the Git CLI to...
2019-11-27
18 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