Microsoft Articles

    Articles ZONE

  • Microsoft

 
Article Author
Written by Valentino Vranken.


In a previous article I announced that I would write a sequel covering how to pass multiple-value parameters from a SQL Server Reporting Services report to a stored procedure. So that's what I will be writing about in this article.

As usual, I will be using the AdventureWorks2008 sample database (running on SQL Server 2008 SP1), downloadable from CodePlex.

...
Article Author
Written by Valentino Vranken.


The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source. The dataset can use a SELECT query, which is the most common way of retrieving data and one that you're probably already familiar with. But it can also use a Stored Procedure (aka stored proc or SP).

The purpose of this article is to demonstrate how data can be ...
Article Author
Written by Valentino Vranken.

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.


...
Article Author
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.
...
 
 
Articles Help

Have a question about Articles or need ideas for what to write? Check out these links:

 
 
Motorola Droid Smartphone

Already purchased the new Motorola Droid? We want to hear from you! Tell us what you think about it and Google's Android 2.0 software.

 
 
Filter: Date
mwvisa1 commented on an article! Reporting On Data From Stored Procedures (part 2) 11/21/09 05:11 PM
mwvisa1 found an article helpful! Reporting On Data From Stored Procedures (part 2) 11/21/09 05:10 PM
mark_wills found an article helpful! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:55 PM
ValentinoV article was published! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:46 PM
ValentinoV article was EE Approved! Reporting On Data From Stored Procedures (part 2) 11/21/09 04:46 PM
harfang wrote a Tip/Trick! Access Fast Lookup in Finance 11/21/09 04:12 PM
ValentinoV wrote a Tutorial! Reporting On Data From Stored Procedures (part 2) 11/21/09 02:00 PM
Jmoody10 found an article helpful! Understanding Group Policy Loopback Processing 11/20/09 02:21 PM
fibo commented on an article! Win7 after XP -- First Impressions 11/20/09 10:50 AM
fibo commented on an article! Excel Tips & Tricks: The Camera Tool 11/20/09 10:41 AM