SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More

SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More

SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More

SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More

SQL SERVER – A Quick Look at expressor Data Quality Solutions

Last month I described the extension framework that allows one to easily add functionality to an expressor Studio installation.  I then used this added functionality – the input and output operators to SalesForce.com – to develop an example application.  But expressor has a second mechanism that allows you to easily enhance the…
Read More

SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More

SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31

Click here to get free chapters (PDF) in the mailbox 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…
Read More