SET STATISTICS IO ON by default in SQL Management Studio

When working with databases and indexes you should always use
"SET STATISTICS IO ON"  and
"SET STATISTICS TIME ON"



For getting the logical reads and execution times and validating the you have index coverage on your queries. But not all are aware that these can actually be set to be on by default...

The check boxes for SET STATISTICS IO and SET STATISTICS TIME are hidden in the Options > Query Execution > SQL Server > Advanced of SQL server management studio

You can find a nice summary of indexing for beginners by Kathi Kellenberger on SQL PASS
http://www.sqlpass.org/24hours/2016/summitpreview/Sessions/Details.aspx?sid=53731