A loop to select all tables and views in a database. I will add more to this, such as executing stored procedures, doing inserts, updates, deletes and whatever other operations I can think of, as time goes on. This is all to test every object in your database with the Tuning advisor.

SelectAll.sql

DECLARE TOCURSOR CURSOR FOR
SELECT('SELECT * FROM ' + name + ';')
FROM sys.tables
UNION ALL
SELECT('SELECT * FROM ' + name + ';')
FROM sys.views


DECLARE @query NVARCHAR(MAX)

   OPEN TOCURSOR
      
      FETCH NEXT FROM TOCURSOR INTO 
      @query

	  WHILE @@FETCH_STATUS = 0
	  BEGIN
	  EXEC (@query)
	  FETCH NEXT FROM TOCURSOR INTO
	  @query 
	  END
	CLOSE TOCURSOR
DEALLOCATE TOCURSOR

Not only has this helped me speed up my database, it also helped me find some old views that don't work.