Interview questions on data warehousing concepts Day 21: what a data warehouse is and why analysts use one for complex queries and analysis.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 20 of 31
Frequently Asked Questions Day 20 explains the key Policy-Based Management terms in SQL Server: target, facet, condition and policy.
SQL SERVER – Interview Questions and Answers – Frequently Asked Questions Day 19 of 31
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
CTE and joins begin Day 16 of the original interview series. The ten questions remain with corrected examples and clearer answers about XML, CLR, synonyms, and locking.
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.