MSSQL Expert (DBA)

Slutfört Publicerat 5 år sedan Betalades vid leverans
Slutfört Betalades vid leverans

I have a table of data around 100M+ records with 50-60 columns. I am trying to show this data in datatable but unfortunately it is taking a lot of time to query pages with higher offsets. So, I want someone to provide a way to deal with this.

So, any freelancer who is experienced with dealing with huge table of 400-500M of data. It should take only few minutes to copy and paste those sql and fix this.

I want to fetch only three column from those 50 columns by the way. I am using MSSQL Server 2017.

If possible you could attach me a video of fetching data in seconds from table of 100M+ of data. Looking forward to work with you.

Looking for expert who wants to earn few bucks for some copy pasting works. Looking freelancers with minimum rates.

Databasadministration Databasutveckling Microsoft SQL Server SQL

Projekt-id: #18047236

About the project

19 offerter Distansprojekt Aktivt 5 år sedan

Tilldelades:

patmilimilind

Greetings I m sql DBA. I could help you if you give me the query and related table structure and index structure Looking forward to work with you. Thanks & Regards Milind

$14 USD inom 1 dag
(24 omdömen)
4.3

19 frilansare har lagt bud på i genomsnitt $24 för det här jobbet

alyelhaddad

Hi there - I'm Aly, I've seen your post and I'm interested. I've had much experience in MS SQL Server and I'd like to know more about the task ahead of us. Is it you're trying to copy this data to a .Net DataTable? or Mer

$30 USD inom 1 dag
(15 omdömen)
4.8
MzHashmi

Hi it can be done by indexing so i can do this job if you want me to using may be team viewer and i guess you are fetching sata to .net so its best to fetch data in other thread other then accessing it on main thread y Mer

$50 USD inom 1 dag
(2 omdömen)
2.8
antaresfa01

Hi I am an experienced developer. I am very much intrested in this project. I will do it in better way. Thanks

$15 USD inom 5 dagar
(3 omdömen)
1.4
arsalsoft95

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Mer

$28 USD inom 7 dagar
(0 omdömen)
0.0
tamer1975

i vb.net programmer with high experience in sql server database even i can make a small program for high and fast search in one day

$25 USD inom 1 dag
(0 omdömen)
0.0
acharyark

I have 12+ years with multiple databases and would love to help you achieve your goals. Please provide more information about the project. Thanks.

$15 USD inom 1 dag
(0 omdömen)
0.0
pavlovicsandra

If I understood you well, your issue is selecting data from huge table. I had this issue before and I was able to resolve it by optimizing my query. If your query is just selecting the data without any conditions in wh Mer

$31 USD inom 1 dag
(0 omdömen)
0.0
khanjahangeer526

Hi I will work with my best experience and according to your desire .

$10 USD inom 2 dagar
(0 omdömen)
0.0
hazemkabil

I have experience as DBA for 4 years in can support you at any time be email or by remote support i still working in the same field just i need to access your database to help you

$25 USD inom 1 dag
(0 omdömen)
0.0
adamwclark

Greetings, One thing we would look at is table indexing. A properly indexed table would improve your query performance. Furthermore we could also look at partitioning the table. Finally, assuming this is not sql azure Mer

$30 USD inom 2 dagar
(0 omdömen)
0.0
muhameed1980

Hi I have a way to make your search quicker out of 100m records. It will help you to make faster searches on other records as well If interested please accept my bid.

$15 USD inom 1 dag
(0 omdömen)
0.0
vjvrunda72

I would like to work with this task, for that I need full description of the task. I have already worked with this type of optimization to get faster result. Looking forward for your response

$20 USD inom 7 dagar
(0 omdömen)
0.0
bhaumik711

-Better understanding of requirement -Deep SSIS knowledge -Deep knowledge about SQL Queries -Healthy knowledge about optimization -Good Knowledge about new features in sql server latest versions -Less time plus qu Mer

$25 USD inom 1 dag
(0 omdömen)
0.0
SureshKumar9330

Making of project is not the matter. i will support the best at any time to get the best. I have handled the project like this. I can assure you the best.

$25 USD inom 2 dagar
(0 omdömen)
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 Mer

$25 USD inom 1 dag
(0 omdömen)
0.0