A while ago I wrote an article called Chart Optimization Tips. This article explained how to optimize a Column Chart. Today I have returned to show you some Pie Chart implementation techniques.
As usual, I will be using the AdventureWorks2008 database, available at CodePlex. The chart itself will be implemented using SQL Server 2008 Reporting Services.
A good server design is one that has no, or very few, single points of failure. Among the most common server components that fail are disks. The commonly used method for providing protection against disk failure is Redundant Array of Independent/Inexpensive Disks, or RAID.
In addition to providing tolerance against disk failure, certain RAID levels increase performance by striping data across multiple disks and therefore distributing I/O load among the disks in the RAID volume. After memory, the disk subsystem is the most important factor affecting SQL Server performance. ...
For the following example I'll be using SQL Server Reporting Services 2008 and the Adventure Works cube running on SQL Server Analysis Services 2008. In case you don't have the AdventureWorks databases and cubes yet, they're available at CodePlex.
I could have called the article "How to implement conditional formatting using SQL Server Reporting Services 2008", but I didn't. Because that's not the only thing what this article is trying to illustrate. The initial purpose of this article is to show you how you can detect missing fields when retrieving data from an OLAP cube. On top of that, the article also ...
In a modern interface, the user expects all controls to be "smart". The interface should understand a user entry even if it doesn't conform to the obvious logic, if it contains a typo, or when it's a clever attempt to accelerate the process.
This article shows a method to make an Access combo box "smarter". The main example comes from a database using a French interface, and dealing with countries. It's been simplified to a single data table (Données), linked to a table of countries (Pays). Internally, the ISO code is used as key...