Hi I have a fact table with 23 columns on which I need to build an index. For design purposes, I need to have a composite key on all the fact table columns but SQL Server 2000 has a limitation of 16 indexes. How do we resolve this? Thanks, Venkatesh ...more >>

Hello, Our project involves a lot of data transformation, processing and matching operations on multi-versioned data sources (physical tables) - each containing about 10 million records. The team for developing and executing these operations includes 15 people that are working on the da...more >>

hello guys! our tempdb is currently 35gig and still growing. we would like to know the best method to shrink it. we tried stopping and starting the service, but we can't really do that whenever a stored proc is running. is there anyway to reduce it while a stored proc is running? HELP...more >>

Hi .. While doing a "Process All Dimensions" (from the right click in Shared Dimensions tab), is it possible to do a COMPLETE PROCESS? By default, it is INCREMENTAL PROCESS and there is no option to do a COMPLETE PROCESS when trying to process all the dimensions. Please let ...more >>

When adding records that would take a SQL Server Developer Ed. table over 2 Gb, I get a message saying "Could not allocate space for object 'MyTbl' in database 'MyDB' because the 'PRIMARY' filegroup if full. How do I get around this error? I thought you datamining folks with experience wi...more >>

I'm reading this data warehouse book and it says that you should never update a record in the fact table unless it is to correct an error but it doesn't say what the consequences of doing this would be. Could someone give me an example of why it is a bad idea to update fields in the fact table...more >>

Please take a look at a free OLAP DHTML browser http://www.xmlabrowser.com/ It requires no client side software other the Internet Explorer 5 or higher. This browser takes advantage of the XML for Analysis SDK. The browser allows you build dynamic olap reports and save them. It also lets...more >>

SQL 2K I created my cube, process data and played with it. My question is , how to make this accessible to my users?? will they have to get into Analysis Manager ?? Is there any automated job to refresh (process) my cube on a daily basis. ?? Thanks Sh ...more >>

I need some help making an informed decision whether to buy the SQL Server 2000 Enterprise or Standard edition. After reading the white paper "Choosing an Edition of SQL Server 2000", i found on page 3 the sentence: "Use Enterprise edition .... if you ... Will be creating und updating ...more >>

We are attempting to create a DTS package to copy tables from one server to another on a weekly schedule. Both servers are SQL 2000. The problem is when we use the wizard within the DTS package designer, the list of source tables does not include the table owner and some of the tables being tr...more >>

Ok situation is like so; I run a website from a SQL2k cluster. However, I wish to replace the entire hardware set up (array and everything). I wish to keep the down time to an absolute minimum. Therefore I'm considering installing the new cluster alongside the old one and setting it as a warm st...more >>

SQL 7.0 and W2K is our environment. I have a very large table 14 million rows. As it takes too long to select data from the table I decided to implement partitioned table. One of date column in the table is always used as a criteria. So I made one table per month and the date column got a...more >>

Hi, I installed BI Accelerator 1.2 and I found one not nice change from version 1.1. Master_Update package loads wrong data into error tables (e.g. S_Fact_Inventory_Errors). In each error table is field Error_Reason and in this field is always just reason "Missing", but in version 1.1 there wa...more >>

SQL SERVER 2K We have 30 databases each for one business units. Now I am consolidating few tables from 30 databases to one database for Analysis purpose. Now my tables in Central db have millions of records. I need some tips to handle this huge tables for query purpose (already applied wit...more >>

Hi All while Processing a cube for I am getting more then 64000 dimension members. And Cube Processing Failed.with error "More then maximum of 64,000 dimension member children for single parent" I this is limitation of Analysis Services . Can any one tell me how I can achieve this ...more >>

Hi! I generated an MDX statement in my vb.6 application. The query works when i run it in the MDX Sample Application. However, when I tried running it in my vb6 application, I keep getting this error and when I checked my cellset's state, it is equal to 1. What am I doing wrong? Please he...more >>

I want to create calculated member which will do the sum of "DollarAmount" depeneds on value in "NewItem" field. If "NewItem" is 1 then take "DollarAmount" else take 0.0 I want to write condition to get sum in calculated member. In following example "ItemId" 2 and 3 is satiesfying conditi...more >>

SQL2K SP3a Win2k SP3 I'm wondering if anybody can help me with performance counters? I've read lots about which counters to use and what values to look for, in an OLTP system. What I'm interested in is which counters and what values are relevant to a data warehousing environment. Disk que...more >>

I'm a former Oracle user who has changed jobs and is starting out in SQL Server. In Oracle 8i and beyond there are extended "Analytical" SQL functions that can only be found in Oracle Enterprise. These include functions like ranking, inter- row comparison, etc. Are there similar "Analy...more >>

Hi, I might be posting this in the wrong section, but I really need help with this, so if this is the wrong section, please direct me to the right one. I am looking for a product/API/anything that shows me relationships between sub-objects. To illustrate, say we have Entity A, which ha...more >>

In Analysis Manager Ive a cube with the following time dimension DayView --> Year --> Week --> Day Ive one measure called Hours What I need to do is to add a calculated measure which will give me the MONTH to date figures. Does anyone know how I can add a m...more >>

I never done datawarehouse operation and yesterday night in front of a pizza, speaking about sql server and oracle with a friend that is taking oracle 9i certification I cannot give y information about datawarehouse capabilities of sql server. Can anyone give me some information about it. Is...more >>