Handling Disk Space Issues During Heavy Index Rebuild Operations

There are times where you need to massively rebuild indexes on some really large databases, after indicated by the relevant analysis of course. However, rebuilding indexes, requires also the adequate amount of free disk space that will be used during the rebuild operation (mainly for the sorting process). Usually the required space is the size of … Read more…

Index Fragmentation in SQL Server and How to Manage it

In this article, we will be discussing about index fragmentation in SQL Server and how you can manage it. SQL Server automatically maintains indexes whenever insert, delete, or update operations are performed on the underlying data.   1. The Two Types of Index Fragmentation in SQL Server Though, in the cases where the underlying data … Read more…

Getting table index information in SQL Server

At some time today, I had to compare the indices of various database tables.To this end, I needed a fast way of getting index information for specific tables. In SQL Server, there is a system stored procedure (hosted in the master database) called sp_helpindex. The syntax for using it is the following: EXEC sp_helpindex ‘schema.table_name’ … Read more…