concept contrast in category sql server

appears as: contrast
SQL Server 2008 Administration in Action

This is an excerpt from Manning's book SQL Server 2008 Administration in Action.

Most technology-focused IT professionals can be categorized as either developers or administrators. In contrast, categorizing a DBA is not as straightforward. In addition to administrative proficiency and product knowledge, successful DBAs must have a good understanding of both hardware design and application development. Further, given the number of organizational units that interface with the database group, good communication skills are essential. For these reasons, the role of a DBA is both challenging and diverse (and occasionally rewarding!).

Together with database components such as stored procedures, the integration of the CLR inside the database engine has blurred the lines between the database and the applications that access it. As such, in addition to what I call the production DBA, the development DBA is someone who specializes in database design, stored procedure development, and data migration using tools such as SQL Server Integration Services (SSIS). In contrast, the production DBA tends to focus more on day-to-day administration tasks, such as backups, integrity checks, and index maintenance. In between these two roles are a large number of common areas, such as index and security design.

In contrast, as shown in figure 2.1, an OLAP, or decision support system (DSS), database is one that stores data for reporting applications that usually have a smaller number of users generating much larger queries. Such queries typically result in sequential I/O, where the physical disks spend most of their time scanning a range of data clustered together in the same part of the disk. Unlike OLTP databases, OLAP databases typically have a much higher percentage of read activity.

Finally, a crucial aspect of disk configuration, and one that we’ll cover in more detail in chapter 9, is the separation of the transaction log and data files. Unlike random access within data files, transaction logs are written in a sequential manner, so storing them on the same disk as data files will result in reduced transaction throughput, with the disk heads moving between the conflicting requirements of random and sequential I/O. In contrast, storing the transaction log on a dedicated disk will enable the disk heads to stay in position, writing sequentially, and therefore increase the transaction throughput.