Optimize 1 MS SQL Server Stored Procedure and advice.

[url removed, login to view]

We have 1 table, and 1 SP needing help with . SQL SERVER 2008R2 (also can work 2012)

- optimize query to return in 1 sec.

- list best practice things to do and avoid

- not sure if dynamic sql or full-text will help, please advise and try if you think will help

- advise how to index and why and how to debug with tuning wizard if possible

- should we use temp table or not?

- should we use a lot of ORs or not?

- notice we also want to try to return the count or hasMoreData

Habilidades: Administração de Bancos de Dados, SQL

Veja mais: sql server or, think debug, Sql Database administration, server 2012 administration, database tuning, sql optimize, SQL Server administration, stored procedure list, 2008r2, sql 2008r2, sql server 2012 full text, database procedure, sql query help, query optimize, server tuning, optimize sql server table, https server, optimize google, optimize index, file sharing server, sql wizard, google sql, edit sql database, sql stored procedure tuning, chauey

Acerca do Empregador:
( 21 comentários ) Houston, Vietnam

ID do Projeto: #5095416

Concedido a:


I have restored your database without issue in SQL 2012. There are many levels to improve your database - both your table structure, stored procedures. I also have extensive fulltext indexing and data partitioning expe Mais

$210 USD em 3 dias
(7 Comentários)

Greetings, Thanks a lot for the invitation. I can help you complete this task as soon as possible. Please let me know your decision. Thanks

$30 USD em 1 dia
(2 Comentários)

13 freelancers estão ofertando em média $74 para esse trabalho


A proposal has not yet been provided

$150 USD in 0 dias
(18 Comentários)

Hi, I'm very interested helping you optimizing your database and stored procedures, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfoli Mais

$105 USD in 3 dias
(33 Comentários)

A proposal has not yet been provided

$30 USD in 3 dias
(13 Comentários)

Hi, I can tune the Stored procedure and table to get results within 1 second. Looking forward to your reply. Feel free to review our excellent track record in completing the projects successfully by reading ou Mais

$79 USD in 3 dias
(5 Comentários)

Hi i have a sound knowledge of sql and optimization is the part i always love to you .i have total 7 years of experience

$25 USD em 1 dia
(7 Comentários)

Hi, Greetings from SRISA Net Solutions, All great ventures start with an idea, a clear vision of what is to become. It is integral for a company to do all its projects in a precise and decisive manner to achieve its Mais

$111 USD in 3 dias
(0 Comentários)

Hellow dear Customer. I have a good experience in optimize sql queryes and i can do this task imediatly. As i see procedure TestSearch return data to web site page. I can upgrate this script and fix bugs. If i start no Mais

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

will do this excellent for you................................ .........................................................................................

$33 USD in 3 dias
(0 Comentários)

Hi, I can perform this task, I am an experienced specialist in large databases tuning, in full-text search, SQLCLR etc. Regards.

$77 USD em 1 dia
(0 Comentários)

Предложение еще не подано

$35 USD in 3 dias
(0 Comentários)

Hi, I am a software professional, SQL certified and can give you perfect advice on the below queries. If you accept my bid lets get started. Regards, Poonam

$25 USD in 3 dias
(0 Comentários)