Tuning Microsoft SQL Server for Teamcenter

GTAC Software Field Bulletin SFB-Teamcenter-6464 has some great tweaks for tuning Microsoft SQL Server 2008 R2 with Teamcenter.

How to Apply Revision Display Filters in Teamcenter

Saw the following question come across the LinkedIn forums regarding how to filter for only the latest Item Revision in Teamcenter:

 

So I thought I would post detailed instructions on how to accomplish this.