title: SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2 (SQL Exam Prep)
author:  Rick A Morelan 
description: Rick has worked for more than 12 years at Microsoft and has attained over 30 Microsoft technical certifications in applications, networking, databases, and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for Northwest University (Kirkland, WA), Volt Technical Education, and Microsoft. He is the author of the SQL Joes 2 Pros book series. In his 12 years at Microsoft, Rick has attained over 30 Microsoft technical certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for Northwest University (Kirkland, WA), Volt Technical Education, and Microsoft. In 1994, you could find Rick Morelan as an Alaska commercial fisherman with non-existent computer skills. His conviction that we all have the ability to go from "Joe" to "Pro" in the IT world - AND that this learning can be enjoyable -informs his approach as an instructor, mentor, and author.
zlib_text: SQL SERVER
  INTERVIEW QUESTION AND ANSWERS
  
  Copyrights
  SQL Server Simplified  Interview Question and Answers
  Copyright © 2021 by Vishal Garg. All rights reserved
  All rights reserved. No portion of this book may be reproduced in any form
  without permission from the publisher, except as permitted by copyright law.
  For permissions contact:
  vishgeek@gmail.com
  
  About the Book
  SQL Server Simplified interview questions is designed to help readers learn
  the basic concepts of SQL Server.
  This book covers all the concepts of SQL Server with the help of Interview
  question and Answers.
  
  Contents
  Copyrights
  About the Book
  Q1. What are Temporary tables?
  Q2. What are Temp variables?
  Q3. What is Table valued parameter (TVP)?
  Q4. Difference between Temporary variables and Temporary tables?
  Q5. What are Sub-Queries?
  Q6. What is a Common table expression (CTE)?
  Q7. What are Types of CTE?
  Q8. Difference between CTE and Temp Table?
  Q9. What is a Stored Procedure?
  Q10.  How to optimize performance of stored 