SQL Server Analysis Services includes the ability to capture information about every query run against a cube. Author Ramunas Balukonis showed us last time how to query this data. This time he brings us a method of interperting which dimensions are actually be used in satifying Analysis Services queries.
2004-11-17
6,484 reads
SQL Server is an amazing business intelligence platforum, including many tools that other vendors force you to buy separately. New Author Ramunas Balukonis is working with this platform and has built a system that helps him perform analysis on just what his Analysis Server is doing.
2004-10-06
9,956 reads
This script drop all indexes from table, including Primary Key contraint. First it del nonclustered indexes, then clustered and at last - drops PK contraint. This scirpt is useful, when you need drop all indexes, like when doing ETL process.
2004-03-17
533 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers