基于SQLServer的应用程序的优化技术

The Technology of Optimizing Applications Based on SQL Server

SQL Server是一个关系型数据库管理系统 ,在一个客户 /服务器模式的 MIS中 ,为了提高整个系统的性能 ,必须根据 SQL Server的特点对应用程序进行优化和调整。文章从数据库设计、索引的建立与使用。

SQL Server is a related database management system.To improve a MIS system performance,it is necessary to optimize and adjust the application program according to SQL Server characteristic in the MIS of Client/Server model.The paper discusses these techniques from the point of view of database design,using index and querying structure.