Thanks Mr. Zhu
These were beneficial. The only part that I wish I had more info is missing index. Since MS said below and I have no knowledge of how to interpret info in Missing Index.
From MS:
"The information provided on Database Missing Indexes page are the suggestions and must not be taken as mandatory actions. You need to analyze where and how many indexes are best suited for optimal performance of your application. Indexes also take storage space, can affect updates for the tables where insertions and deletions are more common, and therefore can be an expensive operation if you overdo it."
