Oracle database and Sql server have totally different structure.Oracle optimization method doesn't work on Sql server environment.
darkstorm is right, on the sqlserver, optimizing the application coding and database structure are most important things.