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,338 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
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Giving a Security Webinar this Wednesday
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Write to backup block blob device failed. Device has reached its limit of allowed blocks.
Picture this, you’re happily backing up your database to a Azure blob storage until...
Forums
An Incomplete Window Definition
Comments posted to this topic are about the item An Incomplete Window Definition
A Lack of Privacy in Smart Cars
Comments posted to this topic are about the item A Lack of Privacy in...
Using the Import Extension in Azure Data Studio
Comments posted to this topic are about the item Using the Import Extension in...
Ask SSC