I knew that there are 4 ways to design data warehouse which are enterprise data warehouse,dependent data mart, independent data mart and federated warehouse but i want to know that which job is suitable to each way?...more >>

Hi, What do you recommand to insure the integrity of a fact table? a cluster index? or a constraint? or an SQL script? do you recommand to allways having a clustering index on a fact table? or just on the dimension tables and 1 index by linked column in the fact table? I don't want to t...more >>

I'm planning to use MS Reporting Services in a project. Does anyone know, if one could realize charts having two different y-axis? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, I hope someone can help me out with this matter. I am trying to implement a DW Solution for an Organization. I need to clarify the following points. (1)what sort of indexes should i use on a DW Database to optimize performance? (2)Is there any easy to follow guides on DW Design...more >>

I installed anaylsis services 6 months after I installed SQL 2000. Do I need to reinstall the SQL Service Packs?...more >>

I'm designing data wareouse where I=B4m taking Data from an=20 operational Database, I=B4m creating dimension tables and=20 facta tables, my question is following. When creating dimension tables I=B4m sometimes taking=20 column from tables in the operational database where=20 there is no inde...more >>

I have a problem in TempDB inflating rapidly up to 3 GB in 4-5 days, there is alot of stored procedures that use temp tables and hash tables the database is about 9 GB Is there any tips that could help out in this...more >>

Hi, Is there a way to efficiently monitor SQL performance using SQL Profiler, and my meaning is to see distinct SQL query sent to server (by ignoring parameter values sent with the queries) this mean that query like select * from users where user_id = 10 and select * from users where user...more >>

Hi, I am trying to come to terms with some of the concepts of datawarehouse architecture design. Utilising Microsoft tools, is it feasible that I build cubes for each subject area and let users report off the cubes with Excel and Reporting services, or should I also expose the data held in the...more >>

I wish to know what is the solution from Microsoft to developing all stages of Data Warehouses on Microsoft platform Is there a single book available for study/reference covering the above question Thanks for the same....more >>

In Access you can analyze tables and use the documenter to write out all of the tables with their permissions, column names, data types etc. Is there a way to do this in SQL Server?...more >>

If there is anybody out there still looking for a comparison of SAP BW to SQL Server I would like to let you know we were one of the large SAP BW sites and having been acutely frustrated with BW we converted to SQL Server OLAP Services. There is a interesting Whitepaper on the Microsoft SAP Cong...more >>

Hi, I've a query to load my data warehouse, like this : select C1, C2, C3.... from T1 inner join T2 ...... where not exists (Select * from FT1 where FT1.A = C1.A and FT1.B=C2.B...) my T1 table (the biggest one) has 240 000 records my FT1 contain only 20 000 records. the result is near 1...more >>

I am using SQL Anywhere (database which comes with powerbuilder) on Windows 2000 Server. I am migrating from Sqlanywhere to sql server 2000. Will there be any problem if I install MS SQl Server 2000 on Windwos 2000 server with sql anywher already in that....more >>

hi guys, m having a problem with the stored procedure copied below. when i try to execute this stored procedure from query analyzer then i get the following error: Error: ---------------------------- Server: Msg 203, Level 16, State 2, Procedure EJ_GetEvents, Line 24 The name 'select sEve...more >>

Is there a function I can put into my select clause that tell me what the line number of the row is? i.e. in Oracle you can do something like (Been a year since I've used Oracle) select rownum, Field1, Field2 from blah Any help is appreciated. Thanks. ...more >>

I would like to incrementally update a cube but I am finding it some what difficult. i would like to include the UID as a dimension and then be able to "get the max(uid) from the cube" and then insert only rows from the fact table that have a greater UID. Can anyone recommend how to do this or ...more >>

Hi All Whether I set roles or non at all to my cubes ANY user can connect and read data from them via excel. Is this a known issue? Anyone else having this problem or am I doing something wrong? Thanks J...more >>

Is there an application out there that will allow us to cleanse/merge-purge the name fields for a consumer as well as for a commercial data warehouse? In other words, we want to take, for example, Walmart, Wal-Mart, Walmart Corp, etc and boil it down to a single WalMart Corporation entity. A...more >>

I am writting a online exhibitor management system. My client can allow to modify their exhibitor's information, however, they will like to create ne record instead of overwrite the current exhibitor's information (exhibitor version control) if you were me, when the client update one of exhi...more >>

I am running V5R2 on client and am trying to link a 400 from SQL Server 2000. Can this be done using IBMDA400? I have gotten to a point with the IBM DB2 UDB that I can connect without error. But now I can't see my tables. This is what I am using for my provider string: User ID=USERNAME;...more >>

What have been experiences out there with indexed views? How are they working for you? What method do you use to maintain them? What is recommended for scenarios where there is a large # of updates to the base table ... are there any issues with rollback tables filling up? Thanks for your h...more >>

Has anyone successfully implement partitioning on multiple columns? My attempts produce the following error: Server: Msg 4436, Level 16, State 12, Line 1UNION ALL view 'Test_pvw' is not updatable because a partitioning column was not found. For example: CREATE TABLE [dbo].[Test_200312_101...more >>

Hi, I have two tables.. Employees Department | EmployeeID | DeptI | Name | Name ...more >>

I'm using Microsoft SQL Server 2000. Recently, I have try to select all the data in a table, INTran table using Query Analyzer for data validation. But a message return from the selection. Please see the below message Server: Msg 823, Level 24, State 2, Line I/O error (bad page ID) detected duri...more >>

I would like to know what protocol / port Report Designer uses when performing the "Deploy " function from the IDE of Report Designer. For some reason it cannot connect with the report server. I can browse the /rs/reportserver directory and can upload the RDL file through the IE. This is probably ...more >>

What's the best way to restore or create a copy of production db (15 GB) on development server and also another copy on same sql server with different name. The copies need to be refreshed on a monthly basis. 1. For doing above things what's best and can some one post sctips or TSQL stateme...more >>

Is there any class(es) to create RDL file? I am creating something like that myself now, but Microsoft already somehow creates RDL files in Visual Studio. So, does Microsft exposes these classes to developers? I am sure they(casses) exist. Thank you. Victor...more >>

Hi to all... I have three tables Cards Card_Edition Edition CardID CardID EditionID Name_Card ...more >>

Does anyone know if you can run reporting services using MSDE? I am just trying to test out the new reporting services....more >>

Hello people When I filter a dimesion the cube is too slow to refresh the data. How to makes a cube really fast when I filter that or any dimension. Thanks ...more >>

My Reporting Services installation failed reporting error code 25619. I can't find any suggested solutions to the error - although it appears others have encountered it. I am trying to install Reporting Services on Windows 2000 Server. Any help would be greatly appreciated. Thanks,...more >>