Verification the performance of Microsoft SQL Server / Nageswary Gannapathy

Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server...

Full description

Bibliographic Details
Main Author: Nageswary , Gannapathy
Format: Thesis
Published: 2002
Subjects:
Online Access:http://studentsrepo.um.edu.my/12421/
http://studentsrepo.um.edu.my/12421/1/nageswary.pdf
_version_ 1848774649042698240
author Nageswary , Gannapathy
author_facet Nageswary , Gannapathy
author_sort Nageswary , Gannapathy
building UM Research Repository
collection Online Access
description Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server side provides security, fault-tolerance, performance, concurrency, and reliable backups. The client side provides the user interface. SQL Server developers have the responsibility for designing and implementing the databases. Designing n good database start with understanding the client’s requirements for the database. SQL Server administrators have the responsibility for the day-to-day tasks of mai ntaining and managing the databases. SQL Server administration involves backing up databases and restoring them when necessary, setting up and managing users, managing database security, managing the replication environment, tuning the database system, and trouble shooting any problems that arise. In this proposal, the Verification the performance of Microsoft SQL Server 7.0 performance will be presented. The proposal mostly will touched on the part of tuning and indexes of SQL Server to perform an optimizer performance and shows how it works on retrieving columns and rows of the real datas. For this purpose, a system will be developed to communicate with SQLServer.
first_indexed 2025-11-14T14:01:39Z
format Thesis
id um-12421
institution University Malaya
institution_category Local University
last_indexed 2025-11-14T14:01:39Z
publishDate 2002
recordtype eprints
repository_type Digital Repository
spelling um-124212021-06-02T20:49:23Z Verification the performance of Microsoft SQL Server / Nageswary Gannapathy Nageswary , Gannapathy QA75 Electronic computers. Computer science QA76 Computer software Microsoft SQL Server is a client / server based relational database management system (RDBMS) that uses T-SQL as its dialect of the SQL language. A client / server database is an application that is divided into a part that runs on a server and a part that runs on workstations (clients). The server side provides security, fault-tolerance, performance, concurrency, and reliable backups. The client side provides the user interface. SQL Server developers have the responsibility for designing and implementing the databases. Designing n good database start with understanding the client’s requirements for the database. SQL Server administrators have the responsibility for the day-to-day tasks of mai ntaining and managing the databases. SQL Server administration involves backing up databases and restoring them when necessary, setting up and managing users, managing database security, managing the replication environment, tuning the database system, and trouble shooting any problems that arise. In this proposal, the Verification the performance of Microsoft SQL Server 7.0 performance will be presented. The proposal mostly will touched on the part of tuning and indexes of SQL Server to perform an optimizer performance and shows how it works on retrieving columns and rows of the real datas. For this purpose, a system will be developed to communicate with SQLServer. 2002 Thesis NonPeerReviewed application/pdf http://studentsrepo.um.edu.my/12421/1/nageswary.pdf Nageswary , Gannapathy (2002) Verification the performance of Microsoft SQL Server / Nageswary Gannapathy. Undergraduates thesis, University of Malaya. http://studentsrepo.um.edu.my/12421/
spellingShingle QA75 Electronic computers. Computer science
QA76 Computer software
Nageswary , Gannapathy
Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_full Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_fullStr Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_full_unstemmed Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_short Verification the performance of Microsoft SQL Server / Nageswary Gannapathy
title_sort verification the performance of microsoft sql server / nageswary gannapathy
topic QA75 Electronic computers. Computer science
QA76 Computer software
url http://studentsrepo.um.edu.my/12421/
http://studentsrepo.um.edu.my/12421/1/nageswary.pdf