Online transaction processing in SQL Server 2008

Source: Internet
Author: User
Tags backup

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.