Hi, Is there any way to use SQL server to store and query geographical data? For example, be able to query all the records that fall withing certain geographical poligon defined by lat/lon coordinates? Thanks. ...more >>

Hi All, this seems like the best place for this question. I've had cause to review the MSFT position/tools in the BI area. I'm surprised!!! I feel like MSFT have made MUCH more progress than generally talked about in newsgroups and customers I work with. All I ever hear from MSFT with respec...more >>

I have to create a Time dimension with day grain in a Datawarehouse system and I don’t know what is the best data type for the primary key... For example 1) I could put Number(8) datatype, then the dates will be: 20050114, 20050115, 20050116.... Then in the fact tables I put the Number(8)...more >>

Hi pals, I am trying to insert binary data in to a field(data type:binary) of a table. Facing a problem with inserting if the binary data contains APOSTROPHE ( ' ). SQL Server expects another APOSTROPHE to end the data. How could I insert that type of data into a binary field ? Could you ple...more >>

Hello, I have 2 cubes, one runs smootly and another one has an error message 'The query could not be processed : The data provider didn't supply any further error information' Anyone know how to solve it, please let me know. Your advice would be appreciated. Thank you and Have a nice...more >>

Is there a SQL function to get FileTime? Filetime is a 64 bit number representing time(up to nano seconds) from January 1, 1601 to what ever the time right now. In C++/C# etc, you have functions to get his value or to convert file time in system time. Ex;: Getfiletime() FileTime 127512...more >>

I work in ETL and had a table clustered index create fail to due to the filegroup being full. Its created after the data is inserted. I just read where I could use the create in tempdb option, but here I don't think that would help. What I am thinking to minimize the space needed, is to...more >>

The data file is a simple Unicode file with lines of text. BCP apparently doesn't guarantee this ordering, and neither does the import tool. I want to be able to load the data either sequentially or add line numbering to large Unicode file (1 million lines). I don't want to deal with another p...more >>

Hi everybody! Just a little question... how could I document a cube?, i mean, for a Q&A enviroment... Something like: Cube Name: Sales Fact Table: Table Nable, Granularity, etc. Dimensions: Name, Type (Standard, Parent child,etc.), Table Name Measures: Name, Type (Numeric, Character, etc...more >>

Hello, Is there a simple answer to this simple question? How to import fixed-width text file? I know the width of the columns but there are so many that I don't want redefine them. I have already a table build for that data with the necessary fields width. In dbase it was such a simple ...more >>

Hi, While enable drillthrough on a cube. There is a option to extra add tables. How is the relationship mananged for these table; do i need to join it to the fact table or the dimension tables. How to remove a table added through this option. Thanks a lot in advance. -- Regards, Yash ...more >>

How do I access AS database meta data (cubes + properties) from an asp.net page? Hans...more >>

I am using one cubes for my sales analysis. When I try to redesign storage and Process the cube from MOLAP to ROLAP, it create error with something related to fail to create index. I didn't change the cube design. What information I need to be careful ?...more >>

Hi All, I would like to be able to connect to a remote SQL Server and fire arbitrary queries, browse tables, and so forth. Very much like MS's "SQL Server Web Data Administrator" (link: http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylan...more >>

I created a cube for Inventory valuation. Every monthend a static Inventory valuation of every item will be put in the cubes. 1. I don't want to aggregate the value across the months; 2. If the user view by year, I would like to system to put the Latest valuation in that year. for examples ...more >>

Dear All Currently runningSQL 2000 Standard I have a parent - child dimesion called Employee where the I have a member key of called Employee_ID which has an int from 1 to 5, and a Parent Key which maps to the Employee_ID called manager ID. I added it to the fact table that contains the E...more >>

i'm facing some difficulties in trying to process a 3 dimensional cube. Everytime i try to process this cube it'll complain that "A member with key "(something)" was found in the fact table but not found in the level (dimension level's name) of the dimension (dimension name) anyone got simi...more >>

Hi, I have a cube where the products we get for repairs under warranty are analyzed. My dimensions are repair date, symptoms, root cause and products. All this works fine my only problems is that I need to put in another dimension called actions (things done to rectify the problems). The ...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hi, There are many points concerning the BI world that are very confused for me. -> What is a relational DB ? A relational DB is for example Oracle, SQLServer or mySQL isn\'t it ? So on a relation DB, we can model an entity/association DB (especially for OLTP) or a Star/snow flake schema f...more >>

hi, tried several issues to solve this ploblem. i want to install reporting service but during the install ill get " Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services." But im a domain admin. doing thi...more >>

My network administrator set up all of the server backups using a Veritas client to back up my sql server 2000 database. When I looked at the database today after a couple of months with no sql server backup it shows the last backup date as September 2004, and the size is over 20 GB. Does anyo...more >>

Hi, I have detached some DBs month ago from an SQL Server 2000 64 Bit Edition and now try to attach them on a 32 Bit environment and get the error message "The file you´ve specified is not a valid SQL Server database file". Are the DB Files of 64 Bit and 32 Bit not Compatible ? or is my f...more >>