Frequently Asked Questions Day 19: tracking changes with Change Data Capture, what CPU pressure means and how to get data from another server.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 18 of 31
Frequently Asked Questions Day 18: copy data from one table to another with INSERT INTO SELECT or SELECT INTO, and learn what catalog views are.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 17 of 31
Frequently Asked Questions Day 17: how to handle errors in SQL Server 2008 with TRY…CATCH, and what RAISERROR does, in my interview series.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 – CTE- Joins
Day 16 of my interview questions and answers series covers CTE and joins, starting with why a CTE makes complex queries easier to read and maintain.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 15 of 31
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.