Frequently Asked Questions Day 9 of my SQL Server interview series: CHECK and NOT NULL constraints, and the difference between UNION and UNION ALL.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 8 of 31
Frequently Asked Questions Day 8 shows how to find the SQL Server version and explains what SQL Server Agent does for a DBA, in my interview series.
Incremental Loads: Moving Only What Changed
Design an incremental load with reliable boundaries, retained change information, delete handling, and a watermark that advances only after success.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 7 of 31
Frequently Asked Questions Day 7 explains the different types of locks in SQL Server, like shared, update and exclusive locks, in simple words.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 5 of 31
Frequently Asked Questions Day 5 explains what is an identity column, how a GUID compares, and what data warehousing means, with short interview answers.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 4 of 31
Frequently Asked Questions Day 4 covers the difference between a function and stored procedure, and what a subquery is, in my SQL Server interview series.