Online transaction processing in SQL Server 2008

Introduction

In the past 20 years, databases have been widely used and developed rapidly. The reduction in storage and technology costs has resulted in massive storage of data and a dramatic expansion of the database. Because of this simple and effective technology, embedded databases and many products came into being, enabling companies to store more data and stay longer, so companies want to merge their servers.

SQL Server 2008 focuses on four key areas to meet today's OLTP database requirements:

· Scalability and performance. SQL Server 2008 enables companies to build database solutions that have the performance and scalability requirements of today's applications.

· High efficiency. SQL Server 2008 provides a real-time (always-on)-capable database application, while minimizing the cost of managing and executing your high-efficiency solutions.

· Security. SQL Server 2008 supports an enhanced security data platform that encrypts your data, examines changes to your data and metadata, merges external keys, and encrypts and signs the data in the backup file.

· Manageability. SQL Server 2008 helps companies reduce the time and cost of managing their data infrastructure by providing innovative and automated policy-based management and improved tools for performance monitoring, troubleshooting, and tuning.

One, scalability and performance

The current trend towards data and server consolidation and the development of remote and built-in databases are essential to the ability of the database server to be scalable and to run multiple applications well. SQL Server 2008 provides a powerful database environment that can be adjusted to your data requirements.

Effective data storage

Although disk space is generally cheap, there are many benefits to reducing the amount of storage space used by your database. Large data files can reduce the speed at which read and write is performed. SQL Server 2008 solves this problem by data compression. Data compression enables you to store your data more efficiently, reduce the storage requirements of your data, and provide an efficient disk input/output (I/O) that significantly increases performance for large loads. SQL Server 2008 also innovatively provides local support for backup compression.

SQL Server 2008 also improves the efficient use of disk space by supporting data types such as XML, VARCHAR (max), and varbinary (max) and vardecimal. The vardecimal data type removes the leading and subsequent 0 of the decimal expression, thus reducing the disk space required to save the data type. In addition, the loss of disk storage efficiency and performance degradation caused by saving null values can be addressed through sparse columns supported in SQL Server 2008.