2007-09-04
1,425 reads
Analysis Services (SSAS)
Scale-Out Querying with Analysis Services
This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers.
2007-08-10
1,700 reads
Analysis Services 2005 defines for peak performance
Analysis Services 2005 in SQL Server improves cube design and performance. Learn how attribute relationships advise Analysis Services how data should be rolled up.
2007-08-08
2,036 reads
2007-07-13
1,517 reads
What is Analysis Services in SQL Server 2005?
Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.
2007-07-02
4,883 reads
Scale-Out Querying with Analysis Services
This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.
2007-06-26
2,630 reads
2007-06-08
1,355 reads
2007-05-28
1,495 reads
2007-05-25
1,567 reads
Conditional Formatting in the Analysis Services Layer
Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.
2007-05-23
1,891 reads
Blogs
6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
Data-driven vs. Data-informed: Let’s Acknowledge the Truth
This comic was retweeted into my timeline on Twitter (I refuse to call it...
Writing Parquet Files – #SQLNewBlogger
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Forums
LOGON Trigger Count
Comments posted to this topic are about the item LOGON Trigger Count
Invisible Downtime
Comments posted to this topic are about the item Invisible Downtime
Empowering Lakehouse Users – Data Engineering with Fabric
Comments posted to this topic are about the item Empowering Lakehouse Users – Data...
Question of the Day
LOGON Trigger Count
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers