Frequently Asked Questions Day 15: what Service Broker is, and where SQL Server stores usernames and passwords, with clear interview answers.
Interview Questions and Answers – FAQ Day 14 of 31
FAQ Day 14 of my interview series starts with the basic functions of the master, msdb, model, tempdb and resource databases in SQL Server 2008.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 13 of 31
Frequently Asked Questions Day 13 explains aggregate functions, what @@SPID returns and the difference between an index seek and an index scan.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 12 of 31
Frequently Asked Questions Day 12: separate drives for performance, free disk space with xp_fixeddrives and why a table has only one clustered index.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 11 of 31
Frequently Asked Questions Day 11: do table and column aliases affect performance, and what is the difference between CHAR and VARCHAR?
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 10 of 31
Frequently Asked Questions Day 10 of my interview series: how to rename a database, a table and a column with sp_renamedb and sp_rename.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 9 of 31
Frequently Asked Questions Day 9 of my SQL Server interview series: CHECK and NOT NULL constraints, and the difference between UNION and UNION ALL.