Home > IT Answers > Development > Maintaining a company table in SQL
SQL Server Ask the Experts
2,585 pts.
 Maintaining a company table in SQL
SQL, SQL tables
I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time better than adding them during the overnight data warehouse update? Our data warehouse is small. How should I go about maintenance of this table?

Software/Hardware used:
ASKED: September 9, 2008  7:56 PM
UPDATED: September 20, 2008  10:06 PM
RELATED QUESTIONS
Answer Wiki:
It really depends on how you are going to be querying the data. If you will be usually querying the budget and the sales information together then store it together. If you will to querying the data separately then overall performance will be improved by storing them separately.
Last Wiki Answer Submitted:  September 20, 2008  10:06 pm  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am not a data warehouse expert, but it sounds to me that mixing budget and sales data in a same table is not a good idea.
Let’s hope someone else answer your other questions.

carlosdl
 63,535 pts.