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
Deciding when to use functions or stored procedures depends on the caller and required work. I want examples behind that choice.
SQL SERVER – Recycle Error Log – Create New Log file without Server Restart
A client’s DBA restarted the server just to start a fresh Error Log. There is no need: you can recycle the log and create a new file without a restart.
SQL SERVER – Index Levels and Delete Operations – Page Level Observation
When you delete data from a table, does SQL Server reduce its size? A page level look at index levels and delete operations, corrected with Hrvoje’s help.
SQL SERVER – TRANSACTION, DML and Schema Locks
Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.
SQL SERVER – Difference Between Update Lock and Exclusive Lock
What is the difference between Update Lock and Exclusive Lock? An Update Lock can sit on a row that has a Shared Lock, then turns Exclusive when it writes.