I’ll just leave this link right here. Good stuff, no further explanation required.

SQL Server Advice: Unexplained