MSSQL Database big table optimisation needed

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

Hello,

I need database professional to optimize my database table

The table is with 1 million records and index optimization is not enough

Some columns have varchar with 4000 symbols

Sample attached

If you have MSSQL knowledge and read description please write Hello Yellow

Administración de bases de datos Desarrollo de base de datos Programación de bases de datos Servidor de Microsoft SQL SQL

Nº del proyecto: #18322824

Sobre el proyecto

29 propuestas Proyecto remoto Activo hace 5 años

29 freelancers están ofertando un promedio de €29 por este trabajo

sumon355

Hello Yellow, As an expert in MSSQL, i am very much interested to help you optimizing your big table. Let's discuss more. Thanks

€80 EUR en 2 días
(314 comentarios)
8.0
Grunty

Hello Yellow, I've inspected the table script and have a couple suggestions to make. Looking forward to your contact, Carlos (a.k.a. Grunty)

€45 EUR en 3 días
(31 comentarios)
7.7
AltiuseCreaton

Hello YELLOW, I can optimize your Mysql tables as per your given brief on project post. Let me know when you available to discuss more in detailed. Regards Rina

€29 EUR en 1 día
(6 comentarios)
5.2
bspanovic

Hi, I'm working with Microsoft SQL Server 18+ years, from its version 2000. I have certified skills and I also worked as Microsoft Certified Trainer for a few years. I have also a broad range of technical knowledge Más

€23 EUR en 1 día
(18 comentarios)
5.6
aishwary9122

Hello Yellow Which version of SQL server you are using? Have you tried Columnstore Index? Let me know if this still available. Thanks

€14 EUR en 1 día
(2 comentarios)
4.5
shadowdancerlv

Hello Yellow The table is not normalized hence any plan will be suboptimal. I will create a more optimized table structure then give you a means to easily retrieve data.

€34 EUR en 1 día
(7 comentarios)
4.6
AndreyBarykin

Hello Yellow. I have big experience as Senior Database Developer/DBA. Expert in MS SQL. I am able to design a competent and optimal database structure. I check your DB Table structure and already know, how to help yo Más

€34 EUR en 2 días
(5 comentarios)
3.5
waqaramjad1993

HELLO database developer here i can do this task i had read your task please talk to me in private chat i had expertise in different languages like SQL,MYSQL, PYthon etc

€39 EUR en 2 días
(1 comentario)
2.3
avinpanwar300

table structure looking fine need to check data so then only we can plan optimization technique . table partition , index .etc regards avin

€24 EUR en 1 día
(2 comentarios)
1.1
jugalpatel96

Hello Sir, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for. Please check my portfolio to check fe Más

€12 EUR en 1 día
(1 comentario)
0.5
ankushagarwal87

Hi I am interested in working in your project & can help you here. I have required experience in query optimization. We can discuss more about need over chat.

€30 EUR en 1 día
(0 comentarios)
0.0
uriarshavin

Hello Yellow I have read your description carefully and I think I can fulfill your requirement. I have built sports betting site with PHP, MySQL and system structuration is my major. I am sure that our cooperation w Más

€24 EUR en 2 días
(0 comentarios)
0.0
visionsoft354

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Más

€28 EUR en 7 días
(0 comentarios)
0.0
kinooy

.I have DBA experiences that I believe able to solved your problem. Table performance optimization is not only by review your sql scripts, its must also see related Database environment itself. Contact me for furth Más

€29 EUR en 10 días
(0 comentarios)
0.0
kikemart

Hello Yellow. Seems to be easy to solve. At least, I've some suggestions about existing indexes. I'll need examples of queries that uses this table. Best regards, Enrique

€12 EUR en 1 día
(0 comentarios)
0.0
acharyark

I have 12+ years of working experience with multiple programming languages and databases including SQL Server, would love to help you achieve your goals. Please provide more information about the project. Thanks.

€15 EUR en 1 día
(0 comentarios)
0.0
shkfiroz

Hi Yellow, I had experienced to maintain and optimize huge table surely I help with the help of existing queries and index and columns

€14 EUR en 2 días
(0 comentarios)
0.0
aviadco1

Hello yellow

€23 EUR en 1 día
(0 comentarios)
0.0
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doin Más

€23 EUR en 1 día
(0 comentarios)
0.0
engrirfanullah

I have done such type work. I am certified Professional Database Administrator.I can do it in little time.

€23 EUR en 1 día
(0 comentarios)
0.0