Optimize database MS SQL Server
€250-750 EUR
Paid on delivery
I have the need to maintain, optimize and fix some faulty design of a Microsft SQL Server 2008 database of about 140 tables and 60 views, occupies about 200gb. The database, despite its size, is EXTREMELY SIMPLE, there are no particular complexity.
The application must necessarily be "always available", is not thinkable lontamente turn it off to do maintenance, for that reason, all operations must be properly designed taking ALWAYS mind that they can not keep the car occupied for more than a few minutes. No interventions "database normalization," understood as a division of tables in sub or groupings of existing tables are required.
The problem to be solved is the lack of foreign keys, the use of primary keys, in association tables, pairs of columns or triple the single primary keys of related entities, all as (unnecessarily) GUID. Moreover, almost all of the columns are erroneously set as nullable.
In the light of these considerations, the goal is that project is to generate one or more scripts for:
- Creation or correction of the primary keys (removing existing and inserting new columns as simple INT IDENTITY);
- The inclusion of foreign keys;
- Correction of the data types of the columns (by setting not nullable if necessary, by changing where possible, data types lighter;
- Optimization of views;
- Creating indexes;
- If necessary you will have to provide for the "cleansing" of tables for the removal of dirty records that do not permit the inclusion of the constraints, of course, this activity must be agreed upon to assess whether the inclusion of such constraints is really essential.
It 'important that as a result of the work you produce one or more scripts that can be run without having to crash the server or completely freeze frame the machine, in private will be notified of the exact configuration but I guarantee that it is properly sized.
Project ID: #12794895
About the project
25 freelancers are bidding on average €546 for this job
Hello, Hope you are doing well! I am a Certified SQL Server DBA & Developer and can help you in this project. I worked on similar projects recently. -------------------------------------------------------------- More
I am sql server dba having more then 10 yrs of experience........... As you mentioned in description i am sure i can surly optimize your database and make it proper as per as your requirment. ........Give me chance a More
Hi sir, I have worked with sql server database tunning. I would like to work with you. Thanks..
Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. I have done many work in Requirements analysis , D More
Certified Microsoft Database Administrator with over 10 years’ experience working on Development, Administration, and Performance Tuning. Experienced in SQL versions of SQL Azure, 2012 2008, 2005, and 2000. My goal is More
Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Thank you, Best regards, David
Hi There, It seems to be a cool requirement, if my profile get shortlisted we can discuss this in detail and finalize the milestone date. Thanks, Kannan Samynathan
Dear Sir/Madam, My name is Alta and I am from Mongolia. From your project declaration, its the kind of job I have been specialized. I have been experienced in programming and databases specially with MS SQL server More
my previous experience working with similar like scenario where I can check for entities linking for this database.
I been working as DBA for 10 years in private and state companies administering SQLserver, Mysql and less time with postgress, in production and contingency environments remotely and onsite. Basically the administra More
My experience as a consultant; required me to go into unfamiliar environments and troubleshoot issues and optimize them in a short period of time.
Hi, I have strong command on SQL Server and i want build my profile on freelancer that's why i was bid as lowest on this task. then after you have to trust on me to complete this task. Warm Regards, Jaymin Patel