|
hardware recommendation
Hi,
I've to recommend a new server for a datawarehouse server which contain some
data warehouse databases (5 databases of 5Gb each)
I plan 6gb of memory and some SCSI drives (5 * 18 gb in raid 5 + 2 * 18 gb
in raid 0 for the tempdb)
there is 200 users for the system for the moment (not concurrently)
and ...
Thu, 3 Jun 2004 23:42:56 -0400
|
COGNOS = CRAP
I cant wait for Microsoft to put these idiots out of business
so i can stop working on the crap
...
Thu, 3 Jun 2004 14:42:17 +0200
|
nice new SQL Server tool available
Hello All,
I wanted to bring to your attention a new utility that I wrote. It enables
you to search for DB entities (tables, stored procedures, etc.) Across
databases and across servers. Among the options, You can search by string to
be found in a stored procedure code, utilize full regular expressions, and
...
Thu, 3 Jun 2004 00:48:21 -0400
|
Transposing data
Is it possible to transpose data from a table?
I have data in the format shown below
Date Hour Price
5/21/04 1 5
5/21/04 2 7
5/21/04 3 9
5/21/04 4 12
Is it possible to have the data print out in this format?
5/21/04 5 7 9 12
I would like to ha ...
Tue, 1 Jun 2004 10:08:12 -0700
|
Pivot table very slow
We are using MS SQL Server 2000 with its Analysis Services and Excel 2002.
We have 3 facts tables (less than 100 rows each) ,
8 dimensions (from 10 to 1000 members),
3 regular cubes and 1 virtual cube (with 20 calculated members).
The pivot table is produced from the virtual cube.
In Excel, when I put 2 dimensions ...
Mon, 31 May 2004 07:51:05 -0700
|
Good references
Can any one Suggest some good books on Data Warehouse
(Begner to Expert Level)
Thanks
Sai ...
Fri, 28 May 2004 12:56:27 -0700
|
Please help!
A new Systems Architect is trying to tell me that a data warehouse typically
contains thousands of fact tables and hundreds of thousands of dimensions.
So you know, my business is in the retail sector. I specifically asked if
he meant THOUSANDS of MEMBERS, not dimensions, and he's sticking to his
statement.
...
Thu, 27 May 2004 10:19:46 -0500
|
AS / Creating cubes
Hi,
I have started to learn Analysis Services. I did the tutorial step by step,
but the last step "create the 'Sales' cube" doesn't work. I get the error
message "Unable to create cube 'sales'" - Unspecified error. It doesn't even
work with the manuelly in footmart creatd cube. What is wrong here? I have
als ...
Thu, 27 May 2004 08:34:13 +0200
|
Time our Error occured-while processing a partition
Hi
We build Analysis Services cubes sitting on Sybase
relational end. We have partitions on of our big
cube. When I try to process any of the partitions(that
are worth 10 days of data) after an hour or so I get an
error "Timeout occurred." and the whole transaction
rollsback.
We are in pressure ...
Wed, 26 May 2004 11:33:39 -0700
|
wrong estimation for a big table (again)
Hi,
I've a table with 20 millions of rows
if I ask the estimated plan for this query :
select * from mytable
the result is: 1 row !!!!!
I've update all my statistics, dropped and recreated my indexes, shrink the
database
but nothing changes !
but if i try this :
select * from mytable where column ...
Wed, 26 May 2004 14:17:22 -0400
|
moving sql database
What is the procedure for moving a database from one c:\
to D:\ on the same computer.
I figure I have to use sql analyzer but once there what
are the steps.
Thanks ...
Wed, 26 May 2004 10:56:34 -0700
|
Writeable Cube
Hello, I need your help
Firstly, Apologize me for my poor english but i've got a big problem: i am French.
My cube is writeable. We enter the "Budget" on level 1 one of a dimension. In fonctiun Sales realised last year, i would like this amount will be shared in Levels 2 and 3 in the same dimension.
Example:The ...
Wed, 26 May 2004 07:46:15 -0700
|
cube partitions strategy
Hi,
I have a product dimension with the following hierarchy:
Category->Brand->Type->...->UPC
There are 10 category items in the hierarchy. In every update, we will add some new products under 1 or 2 categories, which will cause rebuilding the whole cube, which takes very long time.
Can I partition the cube al ...
Tue, 25 May 2004 09:16:04 -0700
|
recovering deleted table
Hi all
Is there a way to reconstruct a table which was deleted without restoring
the whole data base?
Database recovery model is simple. Sqlserver version is 2000 sp3.
TIA
Rea
...
Tue, 25 May 2004 12:26:11 +0200
|
Splitting a text column
I have the following table.
EXISTING TABLE:
COL1 COL2 COL3 MESSAGE
TOM CLERK VA TOM IS A GOOD CLERK. AGE:32,
SINCE:12/12/2001, PLAN:4
ROBERT INTERN DC ROBERT IS A FRESH RECRUIT.
AGE:21, SINCE:1/1/2003, PLAN:3
RICHARD STAFF VA RICHARD IS THE AD'S NEPHEW.
AGE:30, SINCE:12/12/200 ...
Mon, 24 May 2004 10:54:58 -0700
|