List of Questions I have been asked in Interviews

Note: If you are an interviewer and I have a interview scheduled with you in upcoming days or hours, please ask things which are not listed below so that I can have a opportunity to learn few more new things thanks ;) This Page will be updated from time to time as I face new questions: Do you know about System Pages GAM SGAM DCM ? Different modes available in Always on? Whats the difference between Synchronous and Asynchronous modes available? Which technology and version facilitates automatic page repairs in SQL Server? Difference between 2016 and 2012 version of SQL Server (New things that are available or absent). If latency is being observed in secondary replicas and transaction log on primary replica is full and not releasing space even after taking backup and shrinking and there is no open transactions what could be the possible reason and its resolution? What is the need of Bulk log recovery model apart from its minimally logged benefit for bulk operations? How did y