Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.
Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.
Some questions are good for debates. There are so many myths associated with a few subjects that when the discussion starts, it is hard to convince a stubborn friend who is not ready to accept the truth. Let me see you attempt both sides of the following question: What is the difference of table variable and temp tables?
Understanding these special tables is an important thing, although the usages can be a fine line and are often interchangeably used. What are the differences in scope, usage restrictions and more?
This is indeed an eternal debate. I often meet developers who have different beliefs and strong opinions about when to use what. I frequently express developers the internals as well as what the optimal solution between Table Variables and Temporary Tables is, considering their situation. However, I always feel the desire to reach to every single developer and explain the solution in depth. Here is an advice for those who are confused what to use and what. Test it, compare it and implement it. I always suggest to developers to trust SQL Server Engine and test their solution against it and implement it in their application.
SQL Server Interview Questions and Answers ISBN: 1466405643 Page#75-76
Difference Temp Table and Table Variable – Effect of Transaction
Difference TempTable and Table Variable – TempTable in Memory a Myth
ObjectID in Negative – Local TempTable has Negative ObjectID
Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.
Reference: Pinal Dave (http://blog.sqlauthority.com)