Em Andamento

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.

Habilidades: .NET, Oracle, SQL, Área de trabalho do Windows

Ver mais: windows guru, what is guru, to guru, the guru, match guru, i guru, guru to, guru guru, c# guru, c guru, a guru, what is ms sql, sql, sql guru, MS SQL, guru, net keyword, sql optimize, windows core, query email, sql keyword, sql email, net guru, amp sql, need either

Acerca do Empregador:
( 37 comentários ) Bangalore, India

ID do Projeto: #564123

Premiar a:

AlosDeveloper

Hello, please see PMB

$30 USD em 1 dia
(59 Avaliações)
7.0

14 freelancers estão ofertando em média $93 para este trabalho

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 dias
(24 Comentários)
5.0
matharpa

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

$75 USD in 0 dias
(20 Comentários)
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 Mais

$40 USD in 3 dias
(5 Comentários)
4.2
GavaskarAnand

hi see my PMB regards Gavaskar

$40 USD em 1 dia
(3 Comentários)
2.9
giusemaria

Please check my PMB.

$100 USD in 5 dias
(0 Comentários)
0.0
doitright

Lets do it. Please check PM

$80 USD em 1 dia
(0 Comentários)
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 dias
(0 Comentários)
0.0
krishna25051982

i am very excellent in sql server programming.

$30 USD em 1 dia
(0 Comentários)
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 dias
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0
eSoftInc

Dear sir, We have done this work and finish the task in 3 [url removed, login to view] you

$50 USD em 1 dia
(0 Comentários)
4.3
anidr1

Please check PMB

$200 USD em 1 dia
(0 Comentários)
0.0
webOrker

I have a simple solution.

$30 USD em 1 dia
(0 Comentários)
0.0