There is more than one way to create constraints in SQL Server. Quiz 17 of 31 tests them, with a few hints from my co-author Vinod Kumar and me.
SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31
How does CHECKPOINT behavior change with database recovery models? Quiz 16 of 31 asks that, and Vinod Kumar and I share hints to guide you.
SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31
Quiz 15 of 31 tests the difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX). Vinod Kumar and I give hints so you can answer with confidence.
SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31
When does a stored procedure recompile? Quiz 14 of 31 from our interview book asks about those cases, with helpful hints from Vinod Kumar and me.
SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31
The old debate of table variables vs temporary tables comes up in quiz 13 of 31. Vinod Kumar and I share hints to help you pick the right answer.
SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31
Quiz 12 of 31 moves to the cloud with a question on DACPAC and SQL Azure. As always, Vinod Kumar and I offer a few hints before you answer.
SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31
Quiz 11 of 31 covers the non-clustered index and automatic rebuild behavior. Vinod Kumar and I share a few hints to help you answer it correctly.