I have the question about the SQL Server Performance and design
considerations.
I am developing code that is going to deal with a lot of records (specific
detail in the attachment). I am writing code right now that is working fine

I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...M

I have MSSQl 2000 , SP3 with WIn2000
when I transfer from one table to another, 115852 records, le server hangs.
I tried with 70000 records and it worked. even with 90000 records.
With more than 90000 records, the server hangs.

-what is the best method that to implement the near real time updating of a
fact table without affecting all those users who are reading from it?
-fact table in question is only 1.8gb in size, 3.1 million rows, expect near
real time updating of approx 1000 new fact table records ...

I have a fundamental questions regarding my design of my SQL Server
Database.
Current SQL Server 2000 Design Setting (in one server)
-1 Database for OLTP

first of all, i apologize for posting this in multiple forums; i don't
know which is the most appropriate to direct this question to.
on to business... i am trying to import data from an excel file using
the OPENROWSET function in sql server. unfortunately, the results of

My problem:
Antoher server (DTS task) is updating tables in my database on my
server. After these updates i would like to start my dts. So i can be
sure to have the most updated values in my table.

I'm comparatively inexperienced with SQL-Server DB-Design, so neither do I
know, if this is the right newsgroup to ask this question nor if I developed
a complete screwed up concept - so my apologies in advance!
OK, here is my problem.

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates

Hi,
Is it possible to create some kind of indexes on views
based on a substring column ?
View PROD_NAME:

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) ...

What is the best way to merge two really large tables (7,000,000 rows each,
and very wide)?
The table definitions are the same for both tables.
Right now I am using a insert into statement with a selection from one table

Hi All;
I have a table and it has one primary key i.e. BID , one Foriegn Key LOCID
and one EntryDate column which has datetime datatype. It has so many other
columns. We do most of the searches on LocID and EntryDate. This table

I want to setup  a computer or server as a storage server to host database
files.
I'm not looking for a top performance system because its for "small"
datawarehouses and for development / test purpose.

I receive the following error message when I open the Analysis Manager

"Cannot create the temop directory C:\Program Files\ Microsoft Analysis
Services\Bin\...\help80\metadata\metatemp100\. Please verify that you