Yet another way to defrag indexes
A script we use in our company, that rebuilds online=on by default, but takes care of special exceptions.
2016-07-28 (first published: 2014-06-06)
2,348 reads
defragmentation
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.
2011-12-13
5,779 reads
Blogs
Do Yourself a Favor, Check Out Woodler
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love...
Vertically scaling SQL Server online in Kubernetes
One of the new features in Kubernetes v1.33 is the ability to resize CPU...
Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
Forums
What’s the Difference Between AWS RDS and DynamoDB?
When comparing AWS RDS and DynamoDB, the core difference lies in structure and use...
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers