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.
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 – Query to Find Duplicate Indexes – Script to Find Redundant Indexes
Duplicate indexes are pure overhead on every insert, update and delete. Here is my script to find duplicate and overlapping indexes so you can review them.
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 – Database Worst Practices
Let us talk about SQL SERVER – Database Worst Practices. Instead of writing best practices, I am going to write about few of the bad ones.
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.










