Tag Archives: sql server performance tuning

SQL Server SME Interview Experience

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

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 , , , , , , , , , , , , , , , , | 9 Comments

SQL Server Performance Tuning Interview Questions – Part 2 – Indexes

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 , , , , , , , , , , , , , , | 23 Comments