If you are involved data warehousing, or even if you are just a beginner, you may want to check out this article on “Best Practices for Data Warehousing with SQL Server 2008 from the Microsoft MSDN website.