June 2005 - Posts

• Multiple DISTINCT COUNT measures in SSAS 2005

  Analysis Services has a limitation of one distinct count measure for each measure group; in the past, it was a limitation for the single cube. Each distinct count measure cause an ORDER BY clause in the SELECT sent to the relational data source during Read More... Posted Wednesday, June 29, 2005 12:47 AM by Marco Russo (SQLBI) | 3 Comments

• QueryLog in Analysis Services

  More than 2 years ago I posted on the microsoft olap newsgroup a bug on the QueryLog table that Analysis Services uses to log user queries (very important to make usage based optimization). A KB was supposed to be pending, but after two years and a service Read More... Posted Thursday, June 23, 2005 3:32 PM by Marco Russo (SQLBI) | 0 Comments

• Transform Data Task (DTS2000) and SSIS

  My first period using SSIS in a real-world application convinced me that there is a lack of support in migration of SQL2000 DTS packages, expecially in a star schema transformation scenario. Most of my actual DTS packages are combinations of SQL Execute Read More... Posted Sunday, June 19, 2005 4:18 PM by Marco Russo (SQLBI) | 0 Comments

• SSIS2005 feature request (small things)

  May be it's too late, but I think this requests (for SQL Server Integration Services 2005) could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task Read More... Posted Sunday, June 19, 2005 10:23 AM by Marco Russo (SQLBI) | 0 Comments