I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

When installing Reporting Services, I get an error "The installer has encountered and unexpected error installing this package. This may indicate a problem with this package. The error code is 25619. This happens at the very end of the installation process. I am using windows 2000 with SQL ...more >>

Hello, I'm somewhat new to data warehousing, and have some basic questions. Let's say I have a fact table, named sales. The financial analyst would like to be able to sort the sales information based on several customer related attributes. Some of these attributes would include zip code, age...more >>

Hi all, I'm running SQL Reporting Services and my question is: Can I connect the datasource of my reports to a business logic object that returns a dataset instead of using a direct connection to a SQL Server? Anyone that knows if and how this can be done? Regards -Janne Hasslöf...more >>

our logfile run out of space and we canot transact anymore,what shall i do?...more >>

I am trying to defrag my Hard-disk drive. Windows 2000 Server does not defrag my drice compoletely as major portion is occupied by my SQL database whose size is around 2GB. The Defrag program on completion says that it cannot defrag the SQL Database files. Then how do I do it? Is there any way t...more >>

Hi all! I have downloaded the new realese of SQL Server Reporting Services (the real release, not the Beta 2) and gets the following error whenever I try to build, deploy or preview a report. I even got it when I try to shut down the Microsoft .Net IDE. Does anyone have a clue? I have used...more >>

I want to use Linear Regression functions -- example :LinRegSlope -- .in my calculations. Found that it's part of Analysis services. Is there anyway I can get these fuctions in Standard edition of SQL Server2000. If not how can I achevice this .My application connect to SQL Server 2000 Standar...more >>

Hi, We have problem connecting from an ASP page to Analysis services. Here is the scenario: Architecture: - The environment consists of an IIS6 Web Server box and a SQL Server 2000 Sp3a box. - Both boxes are running Windows 2003. - SQL Server and Analy...more >>

Hi , In Excel, there is function -- TREND . I'm wondering how can we acheive this in SQL Server. Function will do something like this. TREND Returns values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Returns the ...more >>

my operational database is sql server 2000 and i want to build data warehouse , can i use that database to crate star schema or i must crate new table to fit fact and dimension table ...more >>

Hello all, I need a whitepaper or link that help me on how to create Datawarehousing using Share point portal 2003 and LOAP thank you on advance ...more >>

Hi, I'm news in Datawarehouse. How to know the update and the insert in database for distribute them to datawarehouse ? SQL Server 2000 have an utilities for it ? I use DTS for the first time to create the datawarehouse (and distribute all the data). But after, how to distribute only the m...more >>

Hello, when I try to call DSO methos NextAnalysisStep (PercentageBenefit As = Double, AccumulatedSize As Double, AggregationsCount As Long) of object Partition.Analyzer, I get error Type Mismatch. I would like to create cube partition each month and design aggregations programatically. But t...more >>

Is there any way in SQL Server to use Standard deviation as an aggregate function. STDDEV -- Is a numeric expression. Aggregate functions and subqueries are not permitted Thanks ...more >>

Hi, I have numerous logs like this one...using the sql serverstring function(with Charindex) or any other function, can someone help me and tell me how do i pull out the 1st value after the symbol '&' (symbol ampersand)? So, i want to split this one field of char into 5 or 6 different fi...more >>

Hi, how to model changes (I've read R.Kimball) in dimensions and (more important) how to implement them in OLAP e.g. MS AS ? I read some papers from scientists but they are not based on commercial solutions - I don't know how to show changes in MOLAP and how to solve the problem. can you gi...more >>

Hi, i want to create offline cubes in excel 2003 and receive following error message: Microsoft OLE DB Provider for Analysis Services: Data source provider error. The olap-database was created with SSABI 1.2, for example with one dimension, one measure and one cube. environment: Win2...more >>

Anybody know a way to make a varchar field not allow duplicates besides making it a primary key? ...more >>

On a quarterly basis I need to refresh a 20 GB database copy with production data. To Do this what's the best method. 1. Back up the production database and restore with a different name. If I restore it on to the same server and during the operational hours, what are the performance issues ...more >>

Hi I understand clustered and non-clustered indexes increase the amount of disk space used i have a table that is 200mb and wondered if I added a non-clsted index how much extra space that would use and is it added to the table size or somewhere else. thanks for any help Mikey...more >>

Hi, I'm just embarking on a data warehousing project for the first time. I have a good understanding of the general principles - dimensional modelling, fact tables, ETL, data staging, cubes, etc. I am interested to get feedback from people who have used BI Accelerator for SQL Server 2000 to...more >>

Im looking for a book that will get me started creating a Datawarehouse on a SQL 2000 server. It will need to cover all areas since im new to this field. Im very familiar with ER modelling and OLTP database design but have never ventured into Datawarehousing. Which books could anyone recommend...more >>

When Does SQL Reporting Services will be Released...more >>

Is it possible to use FK within SQL Server 7, using Enterprise Manager?...more >>

1)Can end users build reports and deploy them easyly? 2)In the final version, will be there all the components requirements to install it? ...more >>

Hi, Happy new year!! I have deleted the log file from windows explorer and attach the database file again, I found that all tables and diagram are still here!! Therefore, I just wonder what's the log file store and how can I use it ? Thanks Ginola...more >>

Hi, I found that there is a setting to set the maximum log file, however, I haven't enable it. Therefore, current log file is 1G. How can I reduce it to 500MB so that I can set the max. log file to 500MB. Happy new year to all Ivan Ginola...more >>