Dev (12/20/2011)

---

At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little choice but hitting the...

lance.a.williams (12/19/2011)

---

PaulB-TheOneAndOnly (12/19/2011)

---

lance.a.williams (12/18/2011)

---

Thank you for the reply. If I provided STAR schema data marts for each business domain and BI tools that connected direct to the datamart...

Adi Cohn-120898 (12/19/2011)

---

I’m not so sure that synonyms affect performance. Can you share a bit more about it? I’ve used synonyms few times when I had more then...

lance.a.williams (12/18/2011)

---

Thank you for the reply. If I provided STAR schema data marts for each business domain and BI tools that connected direct to the datamart for reporting...

Dave-148053 (12/17/2011)

---

Thanks, PaulB and Dev. My goal is to increase readability and maintainability but without doing anything to slow down processing. I will rewrite this code using synonyms...

pereubu (12/19/2011)

---

I have come accross an interesting database design where some of its tables (not central) have not primary keys at all. I am talking about MS SQL 2008....

lance.a.williams (12/16/2011)

---

New to data warehousing. Just curious why one would choose to use an OLAP cube (STAR schema) versus creating a datamart STAR schema. BI tools...

bryon.howe (12/16/2011)

---

We do the same in Oracle by using a Materialized View, I did some research and found Indexed Views in SQL. MS site is kinds blah with examples, do...

For documentation purposes I would fully qualify the non-local table - that way whoever reads the code in the future will be immediately aware that the table is not local.

reported as spam

sqlnaive (12/15/2011)

---

I am database owner for a database around 800 GB. we have auditing tables created for each of the table and triggers populate data in those tables. Currently we...

venus.pvr (12/14/2011)

---

I have tried a few return options and below is what worked for me:

1) return as a ref cursor

2) read oracle procedure from ssrs just like you read a...

You are showing...

sql_jr (12/11/2011)

---

I would want to add a check to it so it could skip and continue with the next indexes. The job abended at this point.

ie: If exists obj...

luis martin ortiz barrutia (12/10/2011)

---

Hello

Is a good practice to put a state field in a table?, so if it is 1 means active, 0 is deleted, so i can recover...