Archived Months
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server data warehouse > december 2003 > threads for december 15 - 21, 2003

Filter by week: 1 2 3 4 5

Any advice on testing Data Warehouse solution?
Posted by Doug Needham at 12/20/2003 10:23:16 PM
We are looking at deploying a data warehouse solution soon that has been being developed for a few months. The development team has been working on developing this for the company. Soon they will be turning this over to the DBA group to do some level of integration testing with the rest of our p...more >>

Experiences in using SQL Server reporting services
Posted by simonlenn NO[at]SPAM yahoo.com at 12/19/2003 3:59:59 PM
Can any of you who have started or evaluated usage of SQL Server reporting services please share your experiences. How come there is still no thread on microsoft.public.sqlserver.* on Reporting services will it be implemented at some stage. Regards Simon...more >>

Good books on SQL Server Reporting Services
Posted by simonlenn NO[at]SPAM yahoo.com at 12/19/2003 3:58:16 PM
Can you please share with me if you are aware of any good books on SQL Server reporting services. Many Thanks Simon...more >>

The Members Count property of level 'LevelName' must be > 0
Posted by Mike at 12/19/2003 2:54:29 PM
I'm trying to build a cube. I am using a view for my account dimension. Here is the definition: ALTER VIEW DemandAccounts AS SELECT * FROM dbo.Account WHERE AccountKey IN (SELECT DISTINCT AccountKey FROM Demand) I only want accounts in my dimension that have made demands. I have verif...more >>

What is the future for BI Accelerator in Yukon
Posted by Claudio Lucio at 12/19/2003 9:21:03 AM
Hi dear all, Anyone have news about the future of BI Accelerator in Yukon SQL version? What do you think about SQL BI Workbench announced by Microsoft? ...more >>

How to format Field ?
Posted by Daniel at 12/18/2003 9:36:05 PM
HOw to set the field (Password) in sqlServer database to '*' For example I key in VB : 12 In SqlServer database should appear : ** Yoir help will be appreaciated daniel....more >>

What does this error mean?
Posted by Mike at 12/18/2003 10:27:57 AM
All, When I process a new cube, I receive this error: Analysis Server Error: More than the maximum of 64,000 dimension member children for a single parent (dimension 'Retention SC Account'S', level 'Account Number', member '1234567890').; Time:12/18/03 9:58:28 AM The underlying fact t...more >>

Problem processing new cube
Posted by Mike at 12/18/2003 9:29:44 AM
All, When I try to "Design Storage" for a new cube, I get a "Fact table size can not be 0" message. (I am in the Cube Editor...) If I focus on the fact table and select "Browse Data", the data is displayed as it should be. So, the fact table size clearly is not "0". From Query Analyzer...more >>



Shrinking Transaction Log
Posted by LIN at 12/17/2003 4:33:44 PM
Hi, We have created a System which does over 1000 transaction every fives minutes with the database. Mostly they are insert and udpdate commands. We have noticed that the transaction log keeps increasing in size (in GBs). We have used the Shrink command at various stages but at some point of t...more >>

Unable to count the members of .....
Posted by Mike at 12/17/2003 4:03:44 PM
All, When I try to process my new cube, I receive the following messages: Unable to count the members of 'LineOfBusinessLevel4' level. Unable to open the record set. Error: Timeout expired. I went into the ODBC administrator and increased the connection pooling timeout to 360 an...more >>


DevelopmentNow Blog