Yeah, I would say it's the same around my area. I get a lot of calls too, most offering 10K to 20K more than what I currently make. When I...

Jayanth_Kurup (10/25/2015)

---

Kirsten : not sure if the flexibility afforded by bringing in columns that one day might be useful offsets the storage and performance overhead of all the rows and...

I think most if not all strive for a separate server for just the DW. That's a given. The question is where to keep staging. In the same database or...

It's my understanding the pages are still going to be under pressure once the data moves to the destination tables from the source tables outside of the DW database? This...

Jayanth_Kurup (10/25/2015)

A staging table is where the TRANSFORM happen in ETL process , it is never meant to be backed up. Staging tables are often used to perform calculations, enrich...

Jayanth_Kurup (10/24/2015)

---

Staging data is transient in nature and behaves similar to a temp table. This means there is going to be a lot of inserts and updates against this table....

I personally adopted the staging schema for my data sources. The file group is still on it's own LUN and all my data sources come in at different times ranging...

A junction table maybe?

Thanks. I did not know that.

I've spent a lot of time with the Hortonworks team in my area. But recently, I have been exploring Cloudera. It's unfortunate to hear they...

Yeah, a covered index in my case would be highly expensive on a table with billion+ rows. But, I get the point.

Sergiy (10/22/2015)

---

With correctly chosen clustered index it does not matter...

Jeff Moden (10/22/2015)

---

xsevensinzx (10/22/2015)

---

Only issue is while anything can be preaggregated ahead of time for rapid reporting. The end users in my case have to re-aggregate the data often to...

Jeff Moden (10/22/2015)

---

xsevensinzx (10/22/2015)

---

J Livingston SQL (10/20/2015)

---

sreeya (10/20/2015)

---

The same Customer may purchase multiple times on the same day plus we have about 100 millions of active users. As I said...

J Livingston SQL (10/20/2015)

---

sreeya (10/20/2015)

---

The same Customer may purchase multiple times on the same day plus we have about 100 millions of active users. As I said facts table is...

Good article.

For me, I'm surely one of those guys looking to expand into the distributed platform waters with Hadoop (particularly with HDFS, HBase, Hive and Impala). I'm not looking to...