MSSQL Expert (DBA)
$10-30 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #18047236
Σχετικά με την εργασία
Ανατέθηκε στον:
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
19 freelancers κάνουν προσφορές κατά μέσο όρο $24 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
Hi I am an experienced developer. I am very much intrested in this project. I will do it in better way. Thanks
"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 Περισσότερα
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
I have 12+ years with multiple databases and would love to help you achieve your goals. Please provide more information about the project. Thanks.
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 Περισσότερα
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
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 Περισσότερα
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.
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
-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 Περισσότερα
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.
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 Περισσότερα
