SQL Server 2008

We are working on a .Net project in which we are using SQL Server 2008 as a database for Online processing and reporting. The tables are normalized and the same tables are used for Online processing and reporting. The screens are designed and developed using .Net technology (aspx pages). We don’t have SQL’s in the pages. All access to the database is done using Stored Procedures. Currently we have only one database. Historical records are stored in the same table. There can only be one current record in a table. We don’t do physical deletes, only logical deletes. We use effective date, end date and a flag for differentiating between current record versus historical record versus logical deleted records.

We have approximately 30 tables that we have created and are using 10 tables from Microsoft .Net User Management application. All these tables are in the same database. We have many stored procedures that we have written. In most of the tables we have created Primary Key’s but no index has been created. We will be adding another 40-50 tables in next couple of months and many more stored procedures.

We are looking at the following task to be accomplished as part of this project. I am looking for someone who has worked on similar tasks before and who is willing to work full time on this project. The query execution time should be excellent. I am attaching couple of tables and stored procedures to give you an idea.

• Review the table layout and suggest if we should create relationships between tables by using Primary Key and Foreign Key

• Based on the suggestion and if required create relationship between tables by using Primary Key and Foreign Key

• Generate a data model in pdf format showing all the relationship

• Look at all the stored procedures to make sure that the stored procedures follows industry best practices and is consistent. Check for redundant stored procedures.

• Look at all the Select queries in the Stored Procedure for the access path to come up with the index requirements

• Create Indexes on the tables

• Optimize the queries for response time. If required modify the query to improve the performance without impacting the business logic.

• Create partition if required. This may not be required now because of the size of the database.

• Database and table sizing based on the projected volume

• Create backup and restore procedures of the database/tables. This procedures should be configurable. The configuration should have at minimum the following parameters: Date, Time, Table Name to backup, Comb-Id (this id identifies an entity and is in all the tables), Entity Name (derived based on Comb-Id).

• We should be able to schedule the data backup or do the data backup in real time. I would like to know the impact of real time backup on the Online processing system.

• Document all the stored procedures. I would like to see in documentation the following: Stored Procedure Name, Input, Output, Tables Used and Function (Select, Insert, Update, Delete)

• Suggest a road map for the new tables and stored procedures.



Tuhin Verma

Kemahiran: SQL

Lihat lagi: which of the following is not part of configuration management, sql database business, online document review, microsoft online business, may 11. 2008, management couple required, input data part time online, execution table, configuration management.net, configuration management .net, best path, best idea for online business, application server configuration, configuration sql server 2008, t-sql with, t-sql in, sql server or, sql server online, SQL Server Admin, sql microsoft access, server technology, online sql server, online sql, modify pdf online, microsoft access sql

Tentang Majikan:
( 0 ulasan ) India

ID Projek: #1558800

13 pekerja bebas membida secara purata ₹17538 untuk pekerjaan ini


Please check The PM.

₹12500 INR dalam 30 hari
(12 Ulasan)

hi, i offer my services for your job, pls see PM.

₹12500 INR dalam 30 hari
(1 Ulasan)

I am working as Database Architect for 5+ years. I can do this projects with best performance and will deliver more than you requested.

₹12500 INR dalam 3 hari
(0 Ulasan)

Hi, I have worked on so many similar projects will try to help asap. Please call me @7322083947 in pst timings, if you are interested to get it done from my end.

₹20000 INR dalam 5 hari
(0 Ulasan)

please check private message

₹12500 INR dalam 20 hari
(0 Ulasan)

We have good knowledge in performance tuning and query making in Oracle,Sql/plsql. As we have understood your entire requirement,we can be able to modify all your query planning which you are using in your stored proc Lagi

₹35000 INR dalam 15 hari
(0 Ulasan)

Please see my private message. Thanks!

₹20000 INR dalam 20 hari
(0 Ulasan)

Working as a SQL Server Developer.

₹15000 INR dalam 15 hari
(0 Ulasan)

I have done lot of this type of projects for Health Care Ministry of Armenia some of them you can see in Comain.org. Give me chance and I will prove my self.

₹20000 INR dalam 25 hari
(0 Ulasan)

Hello, I have understood your requiremnts clearly. I would like you to know that I have been working on SQL Server since last 1 and half year. my project requires extensive and heavy use of SQL Stored procedures. Let m Lagi

₹15000 INR dalam 30 hari
(0 Ulasan)

i have worked on such project. If the data will be huge in your data mart then you have to use SSAS for better performance. If i am committing i will do that at any Cost.

₹20000 INR dalam 15 hari
(0 Ulasan)

Hi, Please see my Private Message. Thanks

₹20000 INR dalam 12 hari
(0 Ulasan)

Hello sir, I have 5+ year Experience in developing website and desktop applications in .NET. I have done many projects like Online Crime Management System in ASP.NET, Online hotel Room Reservation System in PHP, Online Lagi

₹13000 INR dalam 9 hari
(0 Ulasan)