Dear all ,
we have here huge database its interface build using ms-access and the back end is ms-sql the issue now is there are many users existing in different places , now any user ask about any report it takes a very long time and sometime fail to get data, i need idea to improve the performance .
there are many ways but i can not select any
33 freelancers are bidding on average $175 for this job
Hi, Expertise in SQL Server with 8 years industry exposure. By analyzing your tables, indexing and joins in queries it will be improved.If data volume is high we can think about table partitioning.
Hi, I have more then 8 years of experience in MS SQL Server and access. I know so many ways to improve performance of database. You can select me without any hesitation.
Hi, any solution will depend on your exact case, so providing your schema (including queries) and table size would be the bare minimum in evaluating this project.