Database Optimization RND

Now a days our database suck too much so one of my senior make a team so we can optimized a queries who suck CPU time , i did some RND these are the some useful  links that quite helpful may be it can help you as well.

DBCC TRACEON (4199, -1);

https://www.youtube.com/watch?v=Pm8wamJjLAk

https://www.brentozar.com/sql/sql-server-performance-tuning/

https://blog.sqlauthority.com/2007/05/30/sql-server-trace-flags-dbcc-traceon/

https://dba.stackexchange.com/questions/102292/trace-flag-4199-enable-globally
https://sqlserverscotsman.wordpress.com/2016/12/05/trace-flag-4199-query-optimiser-hotfixes/

https://blog.sqlauthority.com/2007/03/23/sql-server-stored-procedure-clean-cache-and-clean-buffer/

http://dbadiaries.com/using-dbcc-freeproccache-to-clear-sql-server-procedure-cache

https://blog.sqlauthority.com/2014/11/02/sql-server-what-are-my-trace-flags-enabled-on-sql-server/

https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

https://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/

https://stackoverflow.com/questions/232333/how-long-should-set-read-committed-snapshot-on-take