Interview Questions – Part II

  1. What are differences between a latch and a lock?
  2. What are the different states of an spid in SQL Server? Explain each state.
  3. What are workers in a SQL Server?
  4. How to reduce network usage by a query?
  5. Explain SOS_Scheduler_Yield wait type.
  6. What are CXPACKET waits? how to avoid that?
  7. Difference between a VAS and buffer pool?
  8. What are the different components of a SQL Engine? Explain how a SQL query is processed by SQL Server (Query lifecycle)?
  9. What are the different components of an RDBMS Engine?
  10. What are primitive and non-primitive way of DBMS functioning? In which type does the SQL server belong to?
  11. What are Memory Clerks?
  12. Explain SQLOS.

Interview Questions: SQL Server DBA


  1. Explain SQL Server Failover Clustering?
  2. How do we check index Fragmentation?
  3. TSQL syntax for Index rebuild and reorg. Difference between the two. How users are effected?
  4. How do we rebuild large indexes? Continue reading “Interview Questions: SQL Server DBA”