Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

An MS Excel Pivot Table generates an MDX statement based on your layout of the Pivot Table. I know that you can explicitly state what your MDX statement is by looking/setting the "commandtext" property, but I don't seem to be able to see what the MDX statement is that the Pivot Table is using w...more >>

I'm trying to move a large OLAP database (one cube's table is larger than 5 gigs) from the "development" server to the "user" server from which it will be accessed. The ARCHIVE command on the development server tells me that "one of the data files is too large to be stored inside a .cab file". ...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

So, we know that the optimizer may choose certain join types under different memory loads or pressures, but will the optimizer vary the degree of paralellism based on the number of already active threads or the system cpu load? -- Kevin Connell, MCDBA ----------------------------------------...more >>

It seems the optimizer would choose a table scan for 2.5 million IO instead of using an existing index for 130 thousand IO....more >>

Hi, I am a programmer with resonable knowledge in SQL SERVER and DTS I am interested in expanding my knowledge in Datawarehousing, Cubes and OLAP Tools what would be the most logical step by step way to do this. What are the various books and websites that teach you these things What are t...more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- ***********************...more >>

I'm attempting to set up a table on SQL Server 2000 for analysis, using source data from an AS/400 server and the IBM AS400 OLEDB Provider which is installed with the Client Access Express product. If I use the DTS Import/Export wizard, the data preview for the "Copy tables(s) and views(s) fro...more >>

I would like my clients had access to the chube metadata. The clients use Excel to access the cube. How can they see the metadata? Paulo *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

hi there, I am doing a college project on MIS(reporting system) with datawarehouse concept for a retail shop . i am using visual basic and sql server 2000. I use about 3 years data and already input them in access and i had sucessfully transform the data into sql server using DTS.I am ...more >>

Hi, I have an Excel Spreadsheet with data that I need to get into a SQL Database. What is the best way to do that? Thanks, Dan ...more >>

I have an access application with a form containing a text box bound to a field in sql server of the "NText" datatype. When the text exceeds a certain very large amount of content (over 130,000 characters) I get an error when adding text to the text box "Text is Too Long to be Edited". It s...more >>

i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>

Hi all, Unfortunately, there's a FLAT Database at my work place ( : ( )... It caused performance problem untill I created views for it. However, now, it happened ( I have no control over.. >_< another long story..) that the users wants to add 22 fields with Data Type bit to the FL...more >>

We've come across the task of how store old data that are no longer in use. This can be temporary session codes, old user profile data etc. System is required to archive everything. We consider two mail alternatives: 1. Store both active and old information in the same database table, and have...more >>

Does anyone know a way to delete records (4 million) and not have it write to the log file? I know in 2k we can turn on simple logging on the database but this is for a SQL 7 server. Thanks in advance, Erik Klein erik.klein@dfait-maeci.gc.ca...more >>

Users in the OLAP administrator group, except administrator, are not able to connect to the Analysis service after SP3 applied. The error shown as follow: Cannot connect to the repository. Analysis server: {server name} Error: Could not use ''; file already in use. Please assist to solv...more >>

hello, can I use fact table as one of the table in dimesion (snowflake schema)? the situation is: I've got invoice number in the level of the one sale line in fact table and a dimesion table with types of sale documents. I want to have hierarchy: DocGroup (comes from the dim table) -> DokKind...more >>

During scheduled backup job (dump database to disk) the system crashed & i got database suspect, and the previous backup file was deleted. Now i restored a 2 days old backup version of that database. I was wondering if dump database to disk with 'with init' option does not replace the old copy u...more >>

Greetings, I am in the process of designing the logical/physical model for our DW and am curious as to what the best practice would be in our scenario. The scenario is we have approximately 4 years of transactions in a single table. Would it be best to leave all the data in one fact table and ...more >>

Has anyone encountered creating offline cubes using microsoft excel? When we to create ours, we keep getting the error, "Data source provider error". We've been able to create offline cubes from datawarehouse projects that was not created using BI Accelerator. Our Facts: 1. Most of our cubes ha...more >>

hello, can anyone tell me how to model flags in star schema or snowflake? is there any tip for this? I've got source table in pharmaceutical system, e.g.: Product table with fields: ProdId, ProdName, Flg_Narcotic, Flg_Psychotroph and data: 1, SomeDrug2, 1, 1 2, SomeDrug, 1, 0 3, SomeDr...more >>

> > ±ÏÒµÖ®ºóÀ´µ½Õâ¸ö³ÇÊÐÒѾ­ÓпìÁ½ÄêµÄʱ¼äÁË£¬±ÏÒµµÄʱºòÔø×ö¹ýÍÆÏúÔ±£¬À­ > ¹ý > ÒµÎñ > £¬×îÉîÇеĸÐÊܾÍÊÇÈËÇéµ­Ä®µÃÏóÒ»±­°×¿ªË®¡£ > > ºóÀ´½øÁËÒ»¼ÒÍâ×ÊÆóÒµ£¬ÏÖÔÚÒѾ­³ÉÁËÈËÁ¦×ÊÔ´²¿µÄÒ»¸öС¾­Àí£¬ÔÚ±ðÈ˵ÄÑÛ > Àï > Ò²Ëã > ÊÇ°×ÁìÒ»×åÁË°É¡£ > > > ¾¡¹ÜÊÇÉú»îÁË¿ìÁ½Äê...more >>

I would like to order the result of a MDX command to a cube by one of the measures. Is it possible? When I´m creating a dimension I can specify that I want to order a dimension by name, key or a property. But my boss would like to see the the customer who sold more in the last month. So It´...more >>