Is there a correct value for fillfactor? Quiz 24 of 31 from our interview book asks that question, and Vinod Kumar and I share hints to help.
SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31
Quiz 23 of 31 is Database Mirroring and Fine-Prints, based on my interview questions book. Vinod Kumar and I share hints to help you answer.
SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31
What is piecemeal restore? Quiz 22 of 31, based on our SQL Server interview book, asks about it, and Vinod Kumar and I share hints to help you.
SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31
What is the difference between create index, drop index and rebuild index? Quiz 21 of 31 asks this, with hints from Vinod Kumar and me.
SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31
In this blog post, we will learn about methods for accessing SQL Server XML DataType. Here is an article which discusses the Author’s Perspective.
SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31
Quiz 19 of 31 compares MERGE or INSERT, UPDATE, DELETE statements. Vinod Kumar and I give a few hints before you choose your answer.
SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31
What is the importance of Resource Database in SQL Server? Quiz 18 of 31 from our interview book asks this, and Vinod Kumar and I share hints.