I will optimize your slow sql server queries and stored procedures

Spain

I speak English, Spanish

Data Analyst

I am an enthusiastic and adaptable professional with a strong willingness to learn and develop new skills. I possess excellent communication and social skills, which allow me to collaborate effectivel...
About this Gig

Are your SQL Server queries or stored procedures slow? Reports that take minutes, timeouts, an app that freezes when it hits the database? I can help.


I am a Computer Science Engineer specialized in databases and data migration. I work every day with advanced T-SQL in high-volume environments, and I taught Database Management Systems at university level for three years.


What I do:

  • Analyze execution plans and find the real bottleneck
  • - Rewrite slow queries and stored procedures
  • - Create or fix indexes
  • - Remove cursors, unnecessary loops and bad joins
  • - Give you a short report explaining what I changed and why

What I need from you:

  • The query or stored procedure (and the table structure if possible)
  • - An idea of how long it takes now and how many rows are involved

I also work with PostgreSQL.


Hablo español: puedes escribirme en español sin problema.


Please message me before ordering if you are not sure the package fits your case.

Database type:

Relational database

Platform:

MS SQL

•

PostgreSQL

•

SQL Server

Expertise:

Normalization

•

SQL

•

Performance

•

Query optimization