I will diagnose and fix your slow sql server query
About this Gig
Is one query bringing your application to a crawl? I've spent 30 years as a database engineer including 20+ years optimizing SQL Server systems for a financial services platform processing $268B+ annually at 1,400+ transactions per second. I know what a slow query looks like at scale, and I know how to fix it.
Send me your problematic query along with its execution plan (or table structure if you don't have one), and I'll identify exactly what's causing the slowdown missing indexes, poor join logic, parameter sniffing, outdated statistics, whatever it is and deliver a rewritten, optimized version along with a plain-English explanation of what changed and why.
This isn't a generic tuning checklist. Every recommendation is based on your actual query and your actual data patterns.
What you'll get:
- A rewritten, optimized version of your query
- A written explanation of the root cause(s)
- Specific index recommendations if applicable
- Before/after performance reasoning based on the execution plan
Expertise:
Speed Optimization
•
Query Optimization
•
Indexing
Platform:
SQL Server
FAQ
Q: I don't have an execution plan. Can you still help?
A: Yes, but it may require the Standard or Premium tier since diagnosis without a plan takes more investigation. I'll let you know before starting.
Q: Do you need access to my database?
A: No, I work from the query text, execution plan, and table/index structure you provide. No live access needed, which also means no security concerns on your end.
Q: What if the fix doesn't actually speed things up?
A: I'll ask clarifying questions before delivery if the execution plan suggests multiple possible causes, so this is rare. If it happens, Standard and Premium tiers include a revision round to iterate.
Q: Can you tune Oracle/MySQL/PostgreSQL queries?
A: My expertise is specifically SQL Server (T-SQL). I don't want to give you subpar advice on a platform I'm not deep in but happy to point you elsewhere if that's what you need.

