SqlServer-QA.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]  UNIQUEIDENTIFIER, [EventType_Id]   ...

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 by measure group. Simplified and enhanced Aggregation Design and Usage-Based ...

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 (SSAS) enable you to easily model complex source schemas and provide great ...

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 information refer to ThePremiers blog. This is much exciting news for ...

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 (SYSMON) is helpful here and the SQL Server 2005 Analysis Services performance monitor counters ...