In Progress

Need a MS SQL Guru

Need a Hard Core MS SQL Guru to optimize a complex query which uses multiple tables and freetext searching:

Here is the situation:

our query searches many fields like first_name,email,last_name & so on

And query is searched for more than 1 keyword like "Alex America", so what we need : the records which match both "Alex" and "America" for any db fields should come first and then fields with only a keyword match i.e. either "Alex" or "America" should come after that.

The query is fully written and we just need to optimize it for proper sorting order.

Need someone fast to solve this within next few hours.

Skills: .NET, Oracle, SQL, Windows Desktop

See more: to guru, the guru, match guru, i guru, guru to, c guru, a guru, sql guru, ms sql, net keyword, sql optimize, windows core, query email, sql keyword, sql email, net guru, amp sql, need either, match records, query optimize, net tables sql, query sql windows, sql multiple tables, email sql, net email sql

About the Employer:
( 36 reviews ) Bangalore, India

Project ID: #564123

Awarded to:

AlosDeveloper

Hello, please see PMB

$30 USD in 1 day
(59 Reviews)
7.0

14 freelancers are bidding on average $93 for this job

nmppatel

I am very good experience with query & stored procedure optimization for Ms-SQL Server 2000/2005. I will provide quick & professional service.

$225 USD in 3 days
(24 Reviews)
5.0
matharpa

I am expert in SQL quries. Check PMB for details.

$75 USD in 0 days
(20 Reviews)
4.6
cnut17

I don't promise to do it in the next hours, but for sure before monday, and probably in the next 24 hours. I assume you are just asking to change the sort order and not making the query faster. I will create an e More

$40 USD in 3 days
(5 Reviews)
4.2
GavaskarAnand

hi see my PMB regards Gavaskar

$40 USD in 1 day
(3 Reviews)
2.9
giusemaria

Please check my PMB.

$100 USD in 5 days
(0 Reviews)
0.0
doitright

Lets do it. Please check PM

$80 USD in 1 day
(0 Reviews)
0.0
drashti41

Hello Sir, i have 4+ years experience in IT field and i am master in Ms SQL . i would like to do it. thanks, Drashti

$100 USD in 2 days
(0 Reviews)
0.0
krishna25051982

i am very excellent in sql server programming.

$30 USD in 1 day
(0 Reviews)
0.0
NareshHariyani

Hellow sir, This is my 1st Bid as freelancer. I have 5+ yrs exp in MS SQL, i wl optimize ur Query as most as possible through my skill in SQL.

$151 USD in 2 days
(0 Reviews)
0.0
yeswant

I am very good at MS SQL and I do have very good 4+ exp in tuning queries. This is my first bid on freelancer.

$150 USD in 1 day
(0 Reviews)
0.0
eSoftInc

Dear sir, We have done this work and finish the task in 3 hours.Thanking you

$50 USD in 1 day
(0 Reviews)
4.3
anidr1

Please check PMB

$200 USD in 1 day
(0 Reviews)
0.0
webOrker

I have a simple solution.

$30 USD in 1 day
(0 Reviews)
0.0