Find Jobs
Hire Freelancers

Recommend table indexes and/or changes on a SQL Server query. Maybe indexed view.

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
I have a complex SQL Server query that needs a performance improvement. The query is the return of a function (ie, the function returns the query statement). I think that performance improvements on this query should be: indexes to be created on tables involved and create one or more indexed views (I know there are limitations, specifications and commands to be performed on the database for this, so if indexed view is to be done on this project, all these items need to be specified as well.) The file for this query is attached. The best description of the steps that are intended to be performed (as long as the price is good as well) wins this project. (I don´t need the solution on your description, just the prove that "you know what you are talking about" :) ). Thanks!
ID del proyecto: 17672284

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hello, As an expert in SQL, i am very much interested to optimize your query. I have checked your attached function and it is tough to understand the query this way. Can you please send me the generated query from this function? Most of the time Index View is not possible in an existing database as it needs much changes. So i would like to avoid indexed view. Indexing in the tables might do the thing. How many records are there in the related tables, how much time it is taking currently and how much time you are expecting after optimization? Please let me know more detail and also the generated query. Thanks
$30 USD en 0 día
5,0 (308 comentarios)
8,0
8,0
15 freelancers están ofertando un promedio de $113 USD por este trabajo
Avatar del usuario
I work with SQL performance problems like this on a daily basis and can get this sorted. Quick Summary about me: SQL Server Certified Master (highest cert), 15 years experience with small - large organisations, SQL (2008R2 - 2017) on-premise and Azure, native English speaker. Any questions let me know.
$70 USD en 1 día
5,0 (26 comentarios)
5,7
5,7
Avatar del usuario
Hi How are you? I am a senior web developer with 5 years of experience in building the websites. I have high skills in Database management. I see what do you want. I hope we will be able to discuss on your project in live chat. I am sure I can deliver high quality product Please consider working with me. I will do my best. Thanks.
$150 USD en 3 días
5,0 (3 comentarios)
4,0
4,0
Avatar del usuario
dear sir , i have experience in sql server +15 years
$166 USD en 3 días
5,0 (4 comentarios)
3,0
3,0
Avatar del usuario
I have 6 year of experience in database development so i can do this as soon as possible. I have hands on experience in sql server, performance tuning, and database structure. I am goo d in DBMS.
$110 USD en 3 días
5,0 (4 comentarios)
2,7
2,7
Avatar del usuario
Currently I am working on PLM software development, I well knowledge in sql backend.
$35 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I will: [1] meticulously study the execution plan of your query and optimize the part that is consuming the most time in query execution. [2] break the query in small pieces and examine the execution plan / time of each separate piece (divide and conquer approach) [3] investigate the possibility of incorporating window functions in the query [4] examine if parameter sniffing comes into play resulting in a non optimal query execution plan To verify my expertise on SQL Server you can review my Stack Overflow profile (search for user Giorgos Betsos).
$61 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
You dont see any reviews in here as i am new to join the site. But i am not new to tuning SQL queries. I wrote so many complex sql queries and tuned very big queries.
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BRAZIL
São Paulo, Brazil
5,0
36
Forma de pago verificada
Miembro desde ago 22, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.