I will fix slow sql server queries and optimize stored procedures
Software engineer, dotNET and SQL Server, legacy app modernization
About this Gig
Is a report, screen or API timing out because of the database? I'll find out why and fix it.
I work with SQL Server in production every day as a software engineer: optimizing queries and stored procedures, reading execution plans and debugging production issues on a platform with real daily users.
What I do:
- Rewrite slow T-SQL queries and stored procedures
- Find missing or unused indexes, fix scans, key lookups and parameter sniffing
- Review execution plans and explain the bottleneck in plain language
- Deliver the optimized script plus a short before/after report
Send me the query or stored procedure, its execution plan and approximate table sizes, and I'll tell you what I can improve before you order. I also work with PostgreSQL. I speak English and Spanish.
Database type:
Relational database
Platform:
MS SQL
•
PostgreSQL
•
SQL Server
Expertise:
SQL
•
Performance
•
Query optimization
FAQ
Do you need access to my server?
Not necessarily. The query or stored procedure script, the actual execution plan and approximate table sizes are usually enough. If needed, a copy of the database or remote access works too.
Do you work with PostgreSQL too?
Yes. My main focus is SQL Server, but I also optimize PostgreSQL queries. Send me a message first so I can confirm scope.
