Well... No matter the actual names of the tables the fact is that in a Dimensional...

baal32 (1/2/2012)

---

I guess what I'm hoping for is something more elegant than what I have now which is a simple table with columns

USERID ITEMID ...

:blink: would you rephrase, please?

If you are retrieving the whole population of the...

Delario (1/6/2012)

---

having successfully clean my data and populated my dimensional and fact tables, my question is how can i insert values from the dimensional tables into the fact table

the following...

sporoy (1/6/2012)

---

Hi, in my SQL Server 2008 EE SP1 environment, one of the application needs to use xp_instance_regread for reading registry values (values like TCPPort in registry), I couldn't find...

This looks like homework - isn't it?

I would agree with Arun in regards to data normalization but I would say that you have to move back one step and design...

Delario (1/6/2012)

---

so far I have created the table base on your advice, and my time table looks likes this:

CREATE TABLE "DIM_TIME"

(

"TIME_KEY" NUMBER,

...

If you really have nothing link next may set you on the right track: http://msdn.microsoft.com/en-us/library/ms174832.aspx

NJ-DBA (1/3/2012)

---

I have an application group who wants to use CDC as a long term solution for tracking changes. They dont want to move historical data to archive tables...

You may want to start here: http://msdn.microsoft.com/en-us/library/dd578580(v=SQL.100).aspx

littlelisa1111 (1/4/2012)

---

select *

from customers.dbo.lead

where leadsource = 'visitor' and Product_Interest = 0

It worked at first until I tried to do an insert to update the product_interest field to "Big Data" if...

Table/Index partitioning has nothing to do with how many filegroups you have -...

A 25Gig database, even if a single table is allocating much of it should not cause much trouble.

If the idea is to expedite ETL process I'll suggest to look into...

Maruthi Shangar (1/2/2012)

---

For one of my requirement I want to cache the data in a table. This table will be dynamically formed with data from different tables. Is there any...