April 2006 - Posts

• SSAS Dimension process fails with unexpected error MDDiscretizer::GetBucketForValue

  The use of DiscretizationMethod=Clusters can cause a process error that is not so clear: Internal error: Unexpected error. File 'mddiscretizer.cpp', row 1532, function 'MDDiscretizer::GetBucketForValue'. This happens because you have an attribute with Read More... Posted Friday, April 28, 2006 4:41 AM by Marco Russo (SQLBI) | 0 Comments

• SSIS service does not start with SP1: workaround

  SQL Server 2005 SP1 seems to stop many working installations of SSIS service. I lost some hour on this problem and only a few days after I discovered a good workaround here . While you install SQL Server 2005, setup procedure brings you to use NETWORK Read More... Posted Thursday, April 27, 2006 6:36 PM by Marco Russo (SQLBI) | 0 Comments

• Improve NTILE performance

  Today I implemented a classification through a NTILE equivalent function. The T-SQL NTILE implementation has very bad perfomance when used against large datasets of rows, so I and Davide Mauri realized a better implementation that Davide posted some weeks Read More... Posted Wednesday, April 19, 2006 7:27 PM by Marco Russo (SQLBI) | 1 Comments

• Update data on published Excel spreadsheets on SharePoint 2007

  I just exited from the SharePoint 2007 odissey to correctly configure settings to get updates from Analysis Services 2005 cubes. The big problem is the Microsoft Single Sign-On service, that is the single component who really make the data connection Read More... Posted Friday, April 07, 2006 5:18 AM by Marco Russo (SQLBI) | 0 Comments

• SqlBulkCopy bug with tablename containg dots

  I'm trying to use SqlBulkCopy removing a C++ DLL I wrote two years ago to create staging tables in SQL Server from remote databases, dynamically creating queries to get data basing on table structure I defined into the staging database. This tool helped Read More... Posted Wednesday, April 05, 2006 7:58 PM by Marco Russo (SQLBI) | 0 Comments

• Microsoft acquires ProClarity

  The news is that Microsoft announced it has agreed to acquire ProClarity . Now a decent client for Analysis Services 2005 will be available from Microsoft, and I hope that a new commercial licensing scheme will allow to small companies to get a mixed Read More... Posted Monday, April 03, 2006 6:41 PM by Marco Russo (SQLBI) | 0 Comments