walshbd (5/8/2013)

---

I have general question regarding design practices for generic child objects which may belong to many different types of parent objects. In my case, I'm keeping a note...

Tyberious Funk (5/8/2013)

---

Like a lot of organisations, we struggle with the fact that a lot of users manage important business data in excel spreadsheets. Wherever possible, I've been encouraging...

Carl0s_ (5/7/2013)

---

Hi, can someone help me with this basic doubt? "tnx in advance"

I have two tables (groups, rol), I need to know what's the correct way to create a relationship

my...

jshurak (5/6/2013)

---

I have a number of jobs that fail because of a linked server message.

Executed as user: Domain\User. Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for...

What's the reason behind "archiving" if as I understand it, all data would be...

Please research SLD of the type 2 (Slowly Changing Dimensions)

if emailing the report is part of Step #1 then the report gets email during Step #1 execution.

Schemas are not folders and you do not want to add any overhead to your database.

Create a...

Statistics ARE used.

To test the concept, do this.

1- Copy two related tables an write...

Table partitioning is not about performance but administration.

In most cases a partitioning strategy is based on thinking how to make your...

rka (4/14/2013)

---

Someone from my company's strategy has said that the Data Warehouse model needs to be:

- Atomic

- 3rd NF

- Relational

But I disagree. I always considered DW models to be:

- Dimensional

-...

Sqlism (4/30/2013)

---

Migrating warehouse from Oracle to SQL Server :

Status: In process

In Oracle : 6 Schemas

In SQL Server: Created a database with 6 Schemas.

-Every Schema has 3 Paritioned and...

Fact is, you already have those books so I would go ahead and use them.

Plenty of information in the net about new/deprecated features between SQL Server versions therefore, I would...

For documentation purposes I would create a table with the same schema, populate it with the "wrong" rows then, just run an update statement on the core table updating columns...