Tag Archives: index tuning

Clustered Index On UniqueIdentifier Column

Posted on April 18, 2019 by uday arumilli

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

SQL Server Performance Tuning Interview Questions – Part 3 – TempDB

Posted on December 17, 2014 by uday arumilli

Sql Server Performance Tuning Interview Questions Performance Tuning – SQL Server Part – 3 – TempDB Q. Tempdb is filling up drastically, what might be the activity that filling up the tempdb? Ans: Usually, tempdb fills up when you are … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , | 14 Comments

SQL Server Performance Tuning Interview Questions – Part 2 – Indexes

Posted on December 17, 2014 by uday arumilli

sql server performance tuning interview questions Performance Tuning – SQL Server Part -2 – Indexes Q. What are the primary differences between an index reorganization and an index rebuild? Ans: Reorganization is an “online” operation by default; a rebuild is … Continue reading →

Posted in Interview Q&A, Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , , | 29 Comments