Browse by Tags

SQL Server 2005 Partitioned Tables and Indexes - learning curve

Published 12 March 8 3:1 AM | SSQA.net

When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...

Filed under: sql server, performance, indexes, data, backup, bi, database, statistics, partition, monitoring, strategy, data warehouse

SQL Server 2008 BI enahncements - what you want is what you get!

Published 25 February 8 2:49 PM | SSQA.net

So far the SQL Server 2008 Analysis Services new features were included until October CTP, top features that Microsoft would like to include within RTM version: New Aggregation designer - to browse and modify aggregation designs that are now shown grouped...

Filed under: sql server, performance, ssis, bi, ssrs, 2008, new, reporting services, enhancement, samples, business intelligence, integration services

New whitepaper available on Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Published 2 January 8 6:36 AM | SSQA.net

Got this update from SQLCAT blog on MSDN about new whitepaper on Analysis Services many-to-many dimensions that helps in MDX query performance optimization steps you need to take care. Many-to-many dimension relationships in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, msdn, bi, download, optimization, whitepaper, Analysis Services, sqlcat

BI - PerformancePoint Server LAST CTP announced!

Published 16 August 7 10:32 AM | SSQA.net

Microsoft released PerformancePoint Server’s LAST Community Technical Preview (CTP) before launch! To date, the CTP program has gathered close to 10,000 members and the product has been enjoying fantastic pre-launch press and analyst coverage. For more...

Filed under: sql server, performance, high availability, bi, bids, performancepoint

Monitor Analysis Services performance

Published 4 May 7 2:12 PM | SqlServer-QA.net (SSQA)

Within the Relational SQL Server engine monitoring the performance is easy with pre-equipped tools such as Profiler, Database tuning advisor and Performance Monitor (SYSMON). How about for BI - Analysis Services monitoring in this case. Again PERFMON...

Filed under: performance, analysis, server, bi