Interview Questions: SQL Server DBA

 Questions

  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”