Frequently Asked Questions Day 8 shows how to find the SQL Server version and explains what SQL Server Agent does for a DBA, in my interview series.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 7 of 31
Frequently Asked Questions Day 7 explains the different types of locks in SQL Server, like shared, update and exclusive locks, in simple words.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 5 of 31
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.