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.