Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
Follow-up work from previous project. Developing SQL query.
Added 1 OCT 2012, 23:26 PM EDT
creation scripts and data are attached. thanks.
Skills: oracle pl/sql, sql, sql server
“Great work as always. Will definitely work with again!
- Understood my problem and asked clarifying questions where necessary.
- Turned this around within 24 hours.
- Solution was correct the very first time.”
I have a few MySQL queries that I need optimized. I also have some that I need written. I don't think they are super complex by any means, but I'm not a SQL expert. The biggest table is about 15 million rows, but the others are much smaller.
These are for two different databases, each of which has less than 10 tables. I'm running this all locally ...
“great work! very timely response and asked great clarifying questions. I will definitely work with Sanjay again in the future.
I had a ~15 million row table in a MySQL database that was taking forever to update, etc. I had tried a few basic things, but was unable to increase the performance. Sanjay was able to increase the performance vastly -- so much so that I am now looking at other ways I can utilized the database. He also optimized a few queries and increased the performance of those. I highly recommend his work.”
I really enjoyed working with you because of clarity of your requirements, your immediate response to my questions and ofcourse showing all the trust in me.
I would definetely like to work again with you in future.
“I really enjoyed working with Russell because I found him very professional. He was very clear with his requirements and very active in giving response to my queries. I would definetely like to work with him again in the future. - Sanjay”
We need to create a unix script that will fetch data from oracle server and save it to a file in csv format. If the data file exists in the file system it will be deleted before creating new data file with the same name. The script will create 5 different files containing data from different tables. This script needs to be executed every day at 1 a...
I really enjoyed working with you. Your requirements were very much clear and you were very much friendly so I never worked on your task under any pressure.
I would really look forward to work on any of your database & scripting requirements coming in future.