Sebanyak 2 item atau buku ditemukan

Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency. Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered. * Identifies and discusses the most common issues database administrators (DBAs) face day-to-day *Provides DBAs with solutions actually used by the authors in enterprise environments *Explores new features which add more control but reduce performance

Some SQL Server database choices are architectural ones. A database
architectural choice is essentially an additional option, as well as the basic SQL
Server 2005 database engine. For example, a decision to use replication to
either distribute or ensure failover capability is a software architectural choice. It's
not always the case, but most often, the overall objective of using add on options,
such as replication, is all about availability and scalability. Making a database
more available ...

The SQL Server 7.0 Handbook

A Guide to Microsoft Database Computing

This concise and authoritative handbook explains how to implement, administer, design and tune Microsoft's leading data base, and how to use it with other data management technologies and products.

OLAP was bom out of work undertaken by relational database guru Ted Codd
and Arbor Software. The entrance of Microsoft in the OLAP market was
established with the purchase of OLAP technology from an Israeli company
named Panorama in October 1996, and since then the technology has been
enhanced and packaged as Microsoft OLAP Services. It is not the intention of the
authors to give the reader a full description of building a data warehouse with
OLAP Services, rather ...