SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Data Warehousing, Reporting Services (SSRS) Rss

   Items 1 to 3 of 3   

Generating lift reports using Reporting Services - Part 1

This tip explores a DMX extension introduced in SQL Server 2005 SP2 that can be used to render lift reports directly in Reporting Services.  Read more...
By Additional Articles 2007/05/24 | Source: sqlserverdatamining.com | Category: data mining
Rating:  Rate this |   Briefcase | 3,379 reads

Top 10 SQL Server 2005 Performance Issues for Data Warehouse and Repor

Relational Data Warehouse or Reporting work loads are characterized by low volumes of very large transactions. These applications are often identified as having predominately read workloads (e.g. Decision Support, Analysis, and Reporting) with periodic feeds or batch loads. It is important to keep these characteristics in mind as we examine the significance of database design, resource utilization and system performance. The top performance bottlenecks or gotchas to avoid for Data Warehouse or Reporting applications are outlined below.  Read more...
By Additional Articles 2007/02/08 | Source: TechNet Blogs | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,472 reads

Implementing Smart Reports with the Microsoft Business Intelligence Pl

This article presents an excerpt from the book, Applied Microsoft Analysis Services, by Teo Lachev. Learn how to author “smart” reports using Reporting Services (SSRS), Analysis Services (SSAS), and SQL Server CLR stored procedures. Get the reports demonstrated in this article by downloading the sample code.  Read more...
By Additional Articles 2006/02/01 | Source: TechNet Blogs | Category: design and theory
Rating:  Rate this |   Briefcase | 3,396 reads
   Items 1 to 3 of 3   
development (2)    
administration (1)    
data mining (1)    
design and theory (1)    
miscellaneous (1)