Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

 

 

 

 

 

Best Practices for Data Warehousing with SQL Server 2008 R2

 

Writers: Mark Whitehorn (Solid Quality Mentors), Keith Burns (Microsoft), Eric N Hanson (Microsoft)

Technical Reviewer: Eric N. Hanson (Microsoft)

Published: December 2010

Applies To: SQL Server 2008 R2, SQL Server 2008

Summary: There is considerable evidence that successful data warehousing projects often produce a very high return on investment. Over the years a great deal of information has been collected about the factors that lead to a successful implementation versus an unsuccessful one. These are encapsulated here into a set of best practices, which are presented with particular reference to the features in SQL Server 2008 R2. The application of best practices to a data warehouse project is one of the best investments you can make toward the establishment of a successful Business Intelligence infrastructure.

 

To review the document, please download the Best Practices for Data Warehousing with SQL Server 2008 R2 Word document.

  • Ask a question in the SQL Server 2008 Forums
  • Send Feedback

Additional resources


  • Last updated on 2011-03-17

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026