Clean SQL database from whitespace, remove duplicate entries and check for fragmentation speed up database
€250-750 EUR
Thanh toán khi bàn giao
We have today a financial application using SQL express 2019, the sql DB is today approx 1,6 GB when dumped to backup. It takes today roughly 17-20 sec before the database is loaded into to application and the data is visible. The company that has created to program doesnt seem to have knowledge of how to clean up the database and optimze.
The database has been upgraded and upgraded since 2008 and there is no way to rebuild the databse unless
we start with an empty database and add all the customers in manually into to the program again. Which is not an option cause it would take very long time to do.
We are now looking for someone that has SQL DB knowledge and are able to script the DB to clean it from duplicate entries, remove fragmentation and speed up the database.
We will be able to provid a virtual server with the database and applications for testing and for the person to work on, you would able to see how the database work with the program and what can be done.
A "Live" VM, no different from what we use in production.
Microsoft Server 2019
Microsoft SQL Express 2019
Wolters Kluwer Bureau
ID dự án: #33343551
Về dự án
48 freelancer chào giá trung bình€572 cho công việc này
Hi, How are you? Upon reading brief details I believe its a doable job I have great experience doing projects with Microsoft SQL Server, Windows Server, Database Administration, Database Programming and VMware. I am co Thêm
Hi, I have 7 years of SQL Server DBA experience and I have done many SQL migration work successfully,I have gone through the project write up and wanted to deep dive in the issues and will fix them. I would like to wor Thêm
Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an as Thêm
We will do your SQL work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in progr Thêm
Hello, I fully understand your requirements. I am ready to start now. Thanks & Regards, Everest Technology
SQL Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom Thêm
Hi, How are you? Upon reading brief details I believe its a doable job I have great experience doing projects with Database Programming, VMware, Windows Server, Microsoft SQL Server and Database Administration. I am co Thêm
I have the expertise and will optimize the db to highest level and remove the duplicate/ raw data in form of procedures... I have more than 11 years of experience in SQL Server database modelling, design, development, Thêm
I have around 10 years of experience in working on this kind of projects. My timezone is EEST, i.e. GMT + 3.
Hey We have a good experience of working in banking organization for about 7+ years. We have been working on huge SQL database which is around 15+ tb and has all transaction data of bank. Have expertise in db, optimiza Thêm
I have 5 years of experience in SQL server. I know how to resolve this issue. I have server generated queries by which i will be rectify database data
Hi, I have several years of experience with Data entry job. I am an Industrial engineer and I am currently pursuing Data Analytics with Google. Currently, I am working in a company as a IT onboarding specialist. I Thêm
Hi there, I am dealing same scenarios from last 5 years, please message for more details. Thank you Mobeen