Common SQL Server Myths by Paul Randal
https://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf
This is a very good article by Paul – interesting read.. Enjoy!
Similar blog post by CSS SQL Server Engineers at Microsoft - https://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx -- an interesting read as well.