Tag Archives: sql tuning

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

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 , , , , , , , , , , , , , , , , | 14 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 , , , , , , , , , , , , , , | 29 Comments