|
|
|
January 2003 March 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
ETL & BINARY_CHECKSUM? Posted by Paul Smith at 4/29/2005 12:00:00 AM We are currently populating our WH/DM using only tools availale in SQL2K
(i.e no Syncsort etc). Some of our modules (controlled via DTS) take,
understandably, a fair amount of time to processand I was ondering if there
was a trick was missing to speed things up. Example: -
In a data acquis...more >>
Analysis Server on Windows 2003 Posted by Michelle at 4/27/2005 4:43:47 PM Hi all,
I am having trouble getting Analysis server to run on my Windows 2003, are
there any KNOWN compatibility issues?
Thanks...M
...more >>
Problem when transfering an important number of records. Posted by oLiVieR CheNeSoN at 4/27/2005 12:00:00 AM Hi,
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.
Any idea ? It might be a bug in MSSQLsvr ? any know...more >>
OLTP vs Reporting Database vs OLAP Database Posted by Robert Lie at 4/25/2005 12:00:00 AM Dear All,
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
-1 Database for OLAP -> Generating Cubes
Planned SQL Server 2000 Design Setting (in two servers):
-1 Database for OLTP -> ...more >>
Start DTS when max value in table has been reached Posted by w.peereboom at 4/22/2005 4:25:02 PM Hello,
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.
For now i start my DTS at a certain time with the job manager. But
sometimes the D...more >>
Table Relation: Question about concept Posted by Klaus Löffelmann at 4/22/2005 3:22:25 PM Hello,
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.
The whole database is about calculat...more >>
index views ? Posted by jerome at 4/21/2005 12:47:57 AM Hi,
Is it possible to create some kind of indexes on views
based on a substring column ?
View PROD_NAME:
Select substring (PROD_STRING,10,20) as PROD_NAME, PROD_NO
from PROD_TABLE
View PROD_TYPE:
Select substring (PROD_STRING,5,5) as PROD_TYPE, PROD_NO
from PROD_TABLE
Of course ...more >>
Streamlining a backup database? Posted by marcmc at 4/18/2005 9:31:02 AM I have a requirement for an automated process to streamline warehouse backups
(some tables only) to only 4 weeks of data for each table archived. I have a
system whereby I apply a suffix to ensure unique table names.
We have alot of old data that builds up quickly. In the near future I will ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
I need help with SELECT statement Posted by Vanessa Lee at 4/14/2005 6:17:21 PM 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
col2 has unique values
col3 can have 5 possible values: 5, 10, 15, 20, 25
Variable @V can be equal to 5 or 10 or 15 o...more >>
Merge Large Tables Posted by Shawn Meyer at 4/14/2005 11:25:27 AM 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
at a time, but it takes way too long. I don't need it to be logged. A all
...more >>
NAS recommandation for dev team... Posted by Jéjé at 4/13/2005 7:37:23 PM Hi,
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.
small = 5 to 20gb (generally a subset of data)
I want to allow a developper to c...more >>
Error message received oopenning Analysis Manager Posted by Paulo Andre Ortega Ribeiro at 4/12/2005 6:43:54 AM
I receive the following error message when I open the Analysis Manager
|(SQL Server 2000):
"Cannot create the temop directory C:\Program Files\ Microsoft Analysis
Services\Bin\...\help80\metadata\metatemp100\. Please verify that you
have enough disk space, and try again"
This directory ...more >>
Is SQL Server 2000 a great datawarehousing DBMS ? Posted by Hassan at 4/8/2005 10:22:32 PM A lot of people in the organisation think that its not especially when it
comes to large datawarehouse systems. What does one do to argue the same ?
They claim Oracle or DB2 are much better.
...more >>
Index Tuning Wizard (Crud?) or just me? Posted by marcmc at 4/6/2005 9:29:06 AM Is it just me or is it that you give it a workload and it recommends the
indexes you already have on your table.
Anybody any experience with this 'tool'? ...more >>
Incremental Load to DataWarehouse table Posted by marcmc at 4/6/2005 9:29:03 AM I have never done it before.
By the term incremental, I mean that I have a fact table and each day I want
to add records to it that do not already exist in the table. I do not want to
truncate and do a full load each day. There are millions of rows. I am
already thinking about Last_RunDate...more >>
Using CASE and TOP statements - HELP Posted by Ali at 4/6/2005 1:13:36 AM Hi,
If i use Case in a query, is there a way to retrieve the top, lets say, 10
for each case within the same query, instead of making different select
statements for each case scenario?
Hence, if i have 3 Cases in the Query, i should have three Top 10's for each
Case?
Will appreciate ...more >>
Performance in Cube generation Posted by Kam at 4/4/2005 6:35:02 PM during the cube generation, I saw the disk utilization in C drive is 100%.
How can I change the temporary drive for the cubes generation?
or
can I share the work load on others drives? nHow?...more >>
RS upgrade Posted by pexiak at 4/4/2005 9:55:04 AM A couple months ago we started a report server MS SQL Reporting Services.
The MS SQL is of course licenced but the Microsoft dealer by mistake sent us
an evaluation version of RS. We've used it for a couple of months and
yestarday it stopped working - its evaluation period passed. As it is
alrea...more >>
Data Modeling Posted by Robert Hamilton at 4/1/2005 8:39:04 AM What's the best Microsoft tool for data modeling of a data warehouse on SQL
Server 2000?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |