Category Archives: Performance Tuning

Index Internals

Posted on April 15, 2015 by uday arumilli

Brad McGehee index internals Good morning Folks, I have gone through an article which is from Brad’s library. We should appreciate him for giving us the best article on Indexes. By understanding this Article we can get some extra knowledge … Continue reading →

Posted in Performance Tuning, SQL Development, SQL Server DBA | Tagged , , , , , , | Leave a comment

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