Overview of Microsoft SQL Server
Microsoft SQL Server is a database management system. It is portable, reliable, flexible, fast, and easy to manage. SQL Server has been developed specifically to take advantage of the best features Microsoft Windows NT has to offer. It is optimized for the multithreaded, preemptive multiprocessing kernel of Windows NT. The many features and options in SQL Server are geared toward multiple users who need concurrent access to high volumes of data. In this chapter, we discuss the primary features that differentiate SQL Server from other database management software.
Microsoft SQL Server 2008 : Overview
SQL Server 2008 delivers on Microsoft’s Data Platform vision by helping your organization manage any data, any place, any time. Store data from structured, semi-structured, and unstructured documents, such as images and rich media, directly within the database. SQL Server 2008 delivers a rich set of integrated services that enable you to do more with your data such as query, search, synchronize, report, and analyze.
InnoDB, MyISAM and disk space
InnoDB uses more disk space than MyISAM because transactions are not free. But how much more will it use? That depends on your schema and data. Depending on the value of pack_keys for a MyISAM table, InnoDB uses 1.24X, 1.35X or 1.46X the disk space as used by MyISAM for the schema and data that I care about. I don't think this is a huge difference and is certainly far from a 3X to 4X overhead.
MySQL Helps Set New World Records for Speed & Price/Performance in Independent Benchmarks
Administered by the Standard Performance Evaluation Corp. (SPEC), the SPECjAppServer2002 test is a recognized industry standard benchmark used to measure performance of J2EE application server platforms connecting with a database, and is designed to model a real-world manufacturing, supply-chain management and order/inventory application.
|
