What are the reasons for using OUTPUT clause? Quiz 10 of 31, from our SQL Server interview book, asks exactly that, and Vinod Kumar and I give hints.
SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31
Quiz 9 of 31 returns to locking, blocking and deadlock in SQL Server. Vinod Kumar and I share hints so you can reason your way to the answer.
SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31
Can ranking functions replace the SQL looping logic of cursor code? Quiz 8 of 31 from our interview book explores it, with hints from Vinod Kumar and me.
SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31
Indexed views come with a list of restrictions. Quiz 7 of 31 tests how well you know them, and Vinod Kumar and I share a few hints along the way.
SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31
What does collation sensitivity mean in SQL Server? Quiz 6 of 31 from our interview book asks just that, with hints from Vinod Kumar and me.
SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31
Quiz 5 of 31 looks at locking and blocking and their effect on database performance. Vinod Kumar and I give hints to guide you to the answer.
SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31
The WHERE clause is part of almost every SELECT statement. Quiz 4 of 31 from our interview book tests it, and Vinod Kumar and I offer a few hints.