Category Archives: Performance Tuning

Clustered Index On UniqueIdentifier Column

Hello all, It’s been a year since we posted a blog. It’s been the busiest year of my life. However, we strongly believe that learning is a journey and it should be a continuing process. Coming to the point, recently … Continue reading

Posted in Database Design, Performance Tuning, SQL Development | Tagged , , , , | 2 Comments

Auto Growth Setting Performance Impact in SQL Server

  This post can help you to understand the Database Auto Growth Setting Performance Impact in SQL Server. If Auto Growth setting is not taking as a serious option means you are missing a great chance to improve the performance. … Continue reading

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , | 12 Comments

Covering Index Performance Impact in SQL Server

Covering Index Performance Impact in SQL Server This post can help you to understand the “Covering Index Performance Impact in SQL Server”. First we’ll understand the covering index basics and we’ll see the performance impact using T-SQL code. Q. What … Continue reading

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , | 2 Comments