Reducing SQL Server I/O Contention during Sync :: Tip 2

Database Storage

All DBAs know that Joining tables on non-indexed columns is the most expensive operation SQL Server can perform.