MSSQL Database big table optimisation needed

Chiuso Pubblicato 5 anni fa Pagato alla consegna
Chiuso Pagato alla consegna

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

Amministrazione Database Sviluppo del Database Programmazione Database Server Microsoft SQL SQL

Rif. progetto: #18322824

Info sul progetto

29 proposte Progetto a distanza Attivo 5 anni fa

29 freelance hanno fatto un'offerta media di €29 per questo lavoro

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 in 2 giorni
(314 valutazioni)
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 in 3 giorni
(31 valutazioni)
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 in 1 giorno
(6 valutazioni)
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 Altro

€23 EUR in 1 giorno
(18 valutazioni)
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 in 1 giorno
(2 valutazioni)
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 in 1 giorno
(7 valutazioni)
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 Altro

€34 EUR in 2 giorni
(5 valutazioni)
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 in 2 giorni
(1 Recensione)
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 in 1 giorno
(2 valutazioni)
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 Altro

€12 EUR in 1 giorno
(1 Recensione)
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 in 1 giorno
(0 valutazioni)
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 Altro

€24 EUR in 2 giorni
(0 valutazioni)
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 Altro

€28 EUR in 7 giorni
(0 valutazioni)
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 Altro

€29 EUR in 10 giorni
(0 valutazioni)
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 in 1 giorno
(0 valutazioni)
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 in 1 giorno
(0 valutazioni)
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 in 2 giorni
(0 valutazioni)
0.0
aviadco1

Hello yellow

€23 EUR in 1 giorno
(0 valutazioni)
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 Altro

€23 EUR in 1 giorno
(0 valutazioni)
0.0
engrirfanullah

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

€23 EUR in 1 giorno
(0 valutazioni)
0.0