|
|
|
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 |
Access Table conversion Posted by mike at 7/30/2005 8:56:01 AM how difficult is it to convert access tables to SQL that can continue to be
linked to an Access GUI....more >>
Relational to DW.? Posted by Luis Esteban Valencia at 7/29/2005 10:46:33 AM Can sombeody point me in the right direction. How can I convert a relational
database to a datawarehouse?
Thanks
...more >>
How do I model Slowly Changing Hierarchy? Posted by ricocali NO[at]SPAM hotmail.com at 7/29/2005 7:43:06 AM We have an anomaly where over time the hierarchy of a dimension
changes. With that, we are only allowed to have "1" hierarchy. It is
basically an organization hierarchy where people get promoted, demoted
and change ranks over time. The business requirement is to be able to
see that 1 appropri...more >>
Multivalued dimensions - modelling Posted by karenmiddleol NO[at]SPAM yahoo.com at 7/29/2005 12:23:27 AM I have a data modelling challenge I need to store multiple values in
the attributes
of a dimension. The dimension I need to model is the Materials
dimension for each material
I have multiple color attributes and many times I have the following
scenario the same material #
will have different c...more >>
how to generate unique key? Posted by yan at 7/27/2005 3:31:02 PM We have a table which data is over a million but less 2 billion. We define an
integer field to hold primary keys but we do not like to choose GUID or
IDENTITY.
Anybody knows any other simple ways to generate unique key?
Thanks.
Yan...more >>
2 Billion records a table Posted by David Liu at 7/21/2005 8:25:02 AM I have a problem in one of my production server:
the rows number is exactly 2 billion records and when you do delete, insert,
that row number was not changed( use sp_spaceused to get the row number)
when you do the DBCC check, you got 0 rows in xxxxxxx pages.
I know SQL Server do not have lim...more >>
Migrating Analysis Services Roles Posted by Tom at 7/20/2005 12:46:12 PM Hi,
I have an Analysis Services database that contains 5 cubes. Is it possible
to migrate the database and cube roles from a development machine to a
production machine by performing a file copy? If so, exactly what has to
copied. If not, what is the best way to do it if it is possible.
...more >>
waittype=LATCH_EX with waitresource=PARALLEL_PAGE_SUPPLIER Posted by Jéjé at 7/18/2005 12:22:09 PM Hi,
I have some issues with a server which is connected to a slow SAN.
the iometer utility says:
SAN= 260io/sec - 8mb/s (32kb block read/write)
Local C:=500io/sec - 15mb/s (32kb block read/write)
To try to improve my loading proces, I have added some files on the local C.
So my staging are...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DW with WInXP Posted by Nacho at 7/15/2005 9:12:44 AM Hi.
I have Question.. If possible install the olap server with winXP to
make cubes in my computer non in the server to practices? if is yes,
what am I Must to do?
thanks
Nacho
...more >>
employee dimension structure question... Posted by Jéjé at 7/14/2005 8:29:01 PM Hi,
I'm looking for samples models for an HR model and specially the employee
dimension table.
What is better a slow changing dimension (with full history in the
dimension)?
or separate dimensions? I mean age, "current" organisation (or organization
unit), position etc... in separate ta...more >>
MS SQL Data Warehousing and Oracle Posted by MC at 7/14/2005 10:46:28 AM I'm looking for some advice/tips on implementing DW on SQL server with data
from Oracle databases. What are the common problems, best practices,
thingies like that?
MC
...more >>
Select Query Posted by Sam at 7/14/2005 9:54:50 AM I have a POITEM Table which has just three columns
InvetoryID, DateofOrder, VendorID
I have under the same InventoryID ,multiple DateofOrders and VendorrID;s.
SO for eg here is a couple of lines of the data,
InvetoryID, DateofOrder, VendorID
ACCKAPCONS01 05/05/2005 ALTPRO0...more >>
Multiple Server Reporting Posted by ERS Developer at 7/8/2005 11:32:08 AM Hi There,
I got a generic DW question.
Let me preface this
I need to design a report that displays data for 3 branches of same
companies, Branch A ,Branch B and Branch C. The problem is that each Branch
has their own distinct server and database. The schema is identical between
them, just ...more >>
Create table, remove records? Posted by vidro at 7/7/2005 6:55:09 AM SQL 2000;
I have a table that has info from 2001 thru 2005, I want to create new
tables and move records from the original table to the new tables, based on
year.
What is the best way to do this?
...more >>
Normalized Data base Posted by Lina Manjarres at 7/6/2005 8:35:03 PM I have been arguing with my partner if we shoud or not design a normalized
data base or denormalized. How, can we know when we should choose one or the
other?
Thanks a lot!...more >>
How to Choose Method to Transfer Data from Production to Reporting database Posted by Resant at 7/6/2005 7:04:02 PM My current project now is how to synchronize (data transfer) between
Production Database & Reporting Database using DTS, but I have no idea
how to do it and using which the best method. Need to know, that two
database have different structure tables - of course - and have a
thousand records insi...more >>
Suggestion Posted by Ajay at 7/5/2005 7:58:03 AM Hi,
We have an application that access multiple databases for generating reports
and running various queries. These databases are segregated as follows:
Server1 DB1 1999-2001
Server2 DB2 2002-2004
Server3 DB3 2005-present
Data is sync-ed up using replication. Database grows at an averag...more >>
Which my star schema models is better? Posted by Resant at 7/4/2005 7:07:14 PM I work in consumer goods company and now design OLAP Data Warehouse.
My OLAP tables consist of :
1. Customer - all our customer data
{CustomerID, CustomerCode}
2. Type - type of the goods
{TypeID, TypeCode}
3. Grade - quality grade of material
{GradeID, CustomerCode, TypeCode, Grade}...more >>
-E switch to start SQL Server? Posted by Jéjé at 7/3/2005 8:36:49 PM Hi,
What is the -E switch in SQL Server?
(not -e but -E)
I have read this:
SQL Server can allocate 4 extents instead of 1 extent when the -E switch is
specified during startup. Hence, the -E switch enables SQL Server to issue
256 KB I/O even if extent fragmentation exists because of pro...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |