White Paper: Precision Considerations for Analysis Services Users
This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain two different answers. While this appears to be a bug, it actually is due to the fact that Analysis Services caches query results and the imprecision that is associated with approximate data types. This white paper discusses how these issues manifest themselves, why they occur, and best practices to minimize their effect.
Microsoft SQL Server 2005 JDBC Driver 1.1
In its continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server 2005. The SQL Server 2005 JDBC Driver is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in J2EE (Java2 Enterprise Edition).
High Performance Data Warehouse with SQL Server 2005
This document discusses things to consider when architecting a large, high-performance relational data warehouse, especially one that is host to unpredictable ad hoc queries. The discussion includes some of the new features of SQL Server 2005 and considerations to take into account when using these features. It also includes methodologies for creating and storing pre-aggregated result sets to facilitate mainstream queries and reports.
Abstract courtesy : Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)
