We have a .NET/[url removed, login to view] app that calls SQL Server.. we need someone to log into our server, document what is slow, optimize it, show us how it was done, step by step. Some of it is Stored procedures calls, some of it is dynamically created SQL from LINQ. There are 4 main areas
get order xml new
get order xml old
to be considered, list the things you would do, tuning wizards, best practices, indexes, table field types, etc...