Neeraj Tripathi

Neeraj Tripathi has 4.5 Years of experience in Database Development and Administration. He started his career with iYogi Technical services as SQL Database developer. After completing an year, he started with DBA administration. Currently, he works with Tricore Solutions as a Consultant-SQL Server DBA.

Follow Neeraj Tripathi via

02 November 2015
02 November 2015

SQL Server Heaps, and Their Fragmentation

In SQL Server, heaps are rightly treated with suspicion. Although there are rare cases where they perform well, they are likely to be the cause of poor performance. If a table is likely to have a large number of changes, then it can become fragmented due to way that space is allocated and forward pointers used. How does one detect this problem? Is it significant? How does one deal with it, if necessary?… Read more