We have hired contractors for database tuning and query tuning and it has been a big disappoint. Even I know more than those people. I'm finding out that people say they know how to do something just to get the work so they can learn how to do something on your dime.
Anyway, enough rants.
I would like recommendations of a contractor who actually does query tuning and database tuning for a living. Every day. Not just once in a while. I want this to be their specialty. I want someone who will do more than to just check if everything is indexed. I can and did do that. They need to know the best method to speed up a big query. I've tried every possible scenario that I know about and have it as fast as I can make it, but it needs to be faster.
Any recommendations for a contractor? We're on sql server 2012.
thanks!
Do you have only one big query ? If so could you please post the actual execution plan ( BTW, how much it takes now and what is your expectation ) ?