The client has made the following changes to the job.
Client prefers freelancers from:
90245, United States
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I have an SQL query that takes approximately 1.5 min to execute. It contains 11 common table expressions, each of which perform a calculation on a unique join or 'where' condition. There are approx 8 tables joined into the query, one of which has 800,000 records.
Seeking SQL database and query expert in the Los Angeles area to troubleshoot, provide suggestions, and implement changes that will reduce execution time, preferably to < 5 seconds.
Please provide a brief description of your experience with databases and SQL coding. Please also provide your suggested path forward, including a cost estimate.
The database is MS SQL Server, and is on GoDaddy as well, accessible through the SQL Server Web Admin.
Added 23 DEC 2011, 13:29 PM EST
Adding 1 further part to this project (in addition to speeding up the query performance):
This query results in an output of approx 7000 values. Add a field to the output that calculates the percentil...
Sign in or Register to see more