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.
The real Data Type: Seven Digits of Precision and Overflow
Four bytes look like a bargain until a total comes out wrong. Watch real round, overflow and drift, then decide when decimal is the safer pick.
SQL SERVER – Find Details for Statistics of Whole Database
Need statistics of whole database in one view? My script uses DMVs instead of the deprecated sp_helpstats and shows each stat, column and last update.
CROSS JOIN: Duplicate Inputs Multiply the Result
CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.