HI
All,
As you see, we are very busy with the SqlServer 2008 lately.
We do see grate improvements with our customer who choose to install it.
I have collected the difference between the editions, so you can easily decide what edition to install.
The licensing is an issue to check before, but when the server you are installing is intend to be a BI one, there is no doubt , choose the enterprise edition for this reasons:
Good luck!
Ronen
Feature | Enterprise | Comments |
Number of CPUs | No Limit | Includes support for multicore processors. |
Partitioning | | Support for large-scale databases |
Parallel Index Operations | | Parallel processing of indexing operations |
Indexed Views | | Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition. |
Online Indexing | | |
Online Restore | | |
Fast Recovery | | Database available when undo operations begin |
Feature | Enterprise | Comments |
Integration Services Advanced Transforms | | Includes data mining, text mining, and data cleansing.
הכוונה ליכולות טיוב נתונים. כמו למדל טיוב כתובות. |
Oracle Replication | | Transactional replication with an Oracle database as a publisher |
Feature | Enterprise | Comments |
Scale Out Report Servers | | |
Data Driven Subscriptions | | |
Infinite Clickthrough | | |
Advanced Business Analytics | | Account intelligence, metadata translation, perspective and semi-additive measures.פרספקטיבות יחליפו את מספר הקוביות הרב בבסיסי הנתונים האולפיים |
Proactive Caching | | Provides automated caching for greater scalability and performance. |
Advanced Data Management | | Partitioned cubes, parallel processing, server synchronization. |
Full Writeback Support | | Dimension and cell writeback |
Advanced Performance Tuning | | Additional options for tuning data mining models for the highest accuracy, performance, and scalability. |
SQL Server Integration Services Data Flow Integration | | Perform data mining prediction and training operations directly in your operational data pipelines. |
Text Mining | | Convert unstructured text data to structured data for analysis via reporting, online analytical processing (OLAP), or data mining. |