Tag Archives: sql server performance tuning

SQL Server SME Interview Experience

Posted on March 29, 2017 by uday arumilli

SQL Server SME Interview Experience This post “SQL Server SME Interview Experience” can help you in understanding and answering the most common question for a SQL Server DBA or Developer. A few days back I got an email from one … Continue reading →

Posted in Interview Q&A, SQL Development, SQL Server DBA | 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