Implement paging with deterministic OFFSET FETCH, correct ROW_NUMBER boundaries, and keyset navigation for deeper SQL Server pages.
Interview Question of the Week #024 – What is the Best Recovery Model?
Choose the best recovery model from your restore requirements, understand bulk-logged limits, and verify the backup chain and log reuse.
Interview Question of the Week #023 – Error Handling with TRY…CATCH
Use error handling with TRY…CATCH, XACT_STATE, explicit rollback, and THROW, while recognizing errors that escape the current scope.
Interview Question of the Week #022: How to Get Started with Big Data?
When an interviewer asks how you would get started with big data, a list of tools is the weakest answer. This post gives a short model answer: start from SQL, learn the core ideas, run one engine on a laptop and build one small project end to end.
Interview Question of the Week #021 – Difference Between Index Seek and Index Scan (Table Scan)
Read index seek and index scan plans accurately, test equality and ranges, and judge lookups and rows read instead of fixed percentages.
Interview Question of the Week #020 – What is the Difference Between DISTINCT and GROUP BY?
Explain the difference between DISTINCT and GROUP BY with a self-contained demo, HAVING filters, and a correlated-subquery plan comparison.
Interview Question of the Week #019 – How to Reset Identity of Table
Reset identity values with DBCC CHECKIDENT, distinguish DELETE from TRUNCATE, and prove that identity alone does not prevent duplicates.