How to get Open Live Writer working with Blogger
Wow – I didn’t blog at all in 2016! While I’m certain that falls squarely on me, perhaps a small part...
2017-02-10
1,561 reads
Wow – I didn’t blog at all in 2016! While I’m certain that falls squarely on me, perhaps a small part...
2017-02-10
1,561 reads
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
999 reads
I appeared on the .NET Rocks podcast show #1149 this week. I had a blast talking about TypeScript, the new...
2015-06-09
783 reads
If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column...
2015-01-14
751 reads
GitHub for Windows doesn't put Git in the PATH by default. If you'd like your Node.js command prompt to have...
2015-01-08
1,305 reads
TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:
https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204
He...
2015-01-06
1,159 reads
My wife and I are happily married. Both of us were surprised the other day when she started getting Match.com...
2014-12-01
680 reads
It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files. ...
2014-11-28
1,639 reads
Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then...
2014-09-11 (first published: 2014-09-08)
10,861 reads
Fiddler is a free program that will log HTTP and HTTPS requests on Windows. These instructions demonstrate how to use...
2014-07-08
2,816 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