How is easy to work with JSON in SQL SERVER 2016 ?
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,524 reads
If you are a developer then surely you might have used JSON (JavaScript Object Notation) but, if not then don’t...
2017-03-28
1,524 reads
To understand RLS (ROW LEVEL SECURITY) let’s understand the different problems first.Problem 1 Suppose, you have a Multi-tenant e-commerce website...
2017-03-27
953 reads
Data security is always one of the important points which can not be ignored. Nowadays if you are working for...
2016-11-27
894 reads
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
810 reads
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
931 reads
This is another article in the series of SQL SERVER 2016 Journey . I am pretty much sure you might aware...
2016-10-16
1,516 reads
In the Series of SQL SERVER 2016 journey, this is our new article. In this article, we are sharing a...
2016-10-15
1,122 reads
Although, I know I am bit late to share this thing on our blog but it says in Indian proverb...
2016-10-11
674 reads
2016-03-29
483 reads
This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...
2015-12-20
827 reads
By Steve Jones
The PASS Summit goes on tour this year, with the final date the first...
By Arun Sirpal
The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...
By Rohit Garg
Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...
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