Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
420 reads
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
420 reads
Red Gate Documentation Update
Looks like the rapid release channel now has a great feature for locking database objects that you...
2015-08-12
277 reads
out of memory, argggh!
Am I the only one that has experienced the various out of memory issues with SSMS? Not...
2015-08-11 (first published: 2015-08-05)
3,431 reads
the problem of monster views
I’ve been working with tuning an application that performs a lot of Entity framework calls,...
2015-08-10
1,315 reads
Have never really played around with the option: SET NOEXEC ON
Turns out this can be a helpful way to validate...
2015-08-07
3,573 reads
Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...
2015-08-04 (first published: 2015-07-28)
3,116 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
504 reads
Was testing a batch file to add a user to a localdb instance. Assumed that my user as admin on...
2015-07-13
317 reads
I'm excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek
Two...
2015-07-06 (first published: 2015-06-30)
11,102 reads
I’m excited to see the future of Sql server management studio with release of SQL Management Studio 2015 Preview. http://bit.ly/1LSu0Ek...
2015-06-30
946 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