Tag Archives: Interview questions

SQL Server Date and Time related Interview Questions

SQL Server Date and Time related Interview Questions This post can help you in answering SQL Server Date and Time related Interview Questions.  Below is the list of queries which are recently asked in SQL Server Developer interviews. These are … Continue reading

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