All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

SQL Server 2008 Enterprise and DW Optimisations

SQL Server 2008 Enterprise and DW Optimisations

  • Comments 2
  • Likes

One of the key areas for the SQL Server 2008 release is to be a scalable Data Warehousing platform. Many organisations have deployed it – with DW ranging from 1TB well into the 60-80TB.

So what makes SQL Server 2008 Enterprise a better choice than SQL Server 2005 is due to the star join and few-outer-row optimisations. A recently released whitepaper goes into further details and also has some test results on IBM servers.


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment