Frequently Asked Questions Day 5 explains what is an identity column, how a GUID compares, and what data warehousing means, with short interview answers.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 4 of 31
Frequently Asked Questions Day 4 covers the difference between a function and stored procedure, and what a subquery is, in my SQL Server interview series.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 3 of 31
Frequently Asked Questions Day 3 explains what is a stored procedure, what is a trigger, and why procedures cut network traffic, in plain interview answers.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 2 of 31
Frequently Asked Questions Day 2 of my SQL Server interview series: what is RDBMS, the properties of relational tables, normalization and more, in short answers.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Introduction – Day 1 of 31
Frequently Asked Questions introduction, Day 1: the pros and cons of the interview question and answer format. Is it helpful learning material or just cheating?
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Complete Downloadable List – Day 0 of 31
The complete downloadable list of my 31-day series of SQL Server interview questions and answers, with a free PDF for offline review at the end.
SQL SERVER – Question to You – When to use Function and When to use Stored Procedure
When to use function and when to use stored procedure? I think they are apples and oranges, yet I see them used interchangeably, so I want your view.