MS SQL Server 2008 vs 2008 R2
SQL Server 2008 thiab SQL Server 2008 R2 yog siv los siv cov ntaub ntawv tswj thiab kev lag luam ntse tej yaam num. SQL Server muaj ob qhov chaw sib koom ua ke rau kev tswj hwm server thiab kev tsim khoom lag luam. Cov neeg siv kev paub txog hauv Containers thiab Visual ntsiab tsim hauv SQL 2005, tuaj yeem ua haujlwm hauv SQL Server 2008 thiab SQL Server 2008 R2 thiab. Ob lub versions muab tej yaam num (SQL neeg rau zaub mov scripts, Analysis server scripts) uas yog teem rau hauv cov kev daws teeb meem. SQL neeg rau zaub mov muaj ob "studios" los ua cov haujlwm txhim kho thiab tswj cov haujlwm. Tus neeg siv tuaj yeem tsim thiab tswj SQL server database cav thiab ceeb toom kev daws teeb meem hauv Management studio. Los ntawm kev siv cov kev pabcuam tshuaj xyuas, qhov ntev thiab cov qauv mining hauv kev lag luam kev txawj ntse txhim kho studio cov neeg siv tuaj yeem tsim cov kev txawj ntse kev lag luam
SQL Server 2008
SQL Server 2008 lub hom phiaj ua kom cov ntaub ntawv tswj hwm tus kheej, tswj tus kheej thiab kho tus kheej. Cov ntawv no txhawb nqa kev siv cov ntaub ntawv tsim thiab cov txheej txheem ib nrab, suav nrog cov ntawv xov xwm digital (duab, yees duab, suab, thiab lwm yam …). SQL Server 2008 tuaj yeem yog cov ntaub ntawv khaws cia rau cov ntaub ntawv sib txawv: XML, email, lub sijhawm / daim ntawv qhia hnub, cov ntaub ntawv, cov ntaub ntawv, spatial, thiab lwm yam nrog rau kev tshawb nrhiav, lus nug, tsom xam, sib koom, thiab synchronization hla txhua hom ntaub ntawv. Yeej SQL neeg rau zaub mov 2008 muaj cov yam ntxwv hauv qab no:
- Database Engine
- Kev Tshawb Fawb - Cov Ntaub Ntawv Ntau Yam
- Kev Tshawb Fawb - Cov Kev Pabcuam Cov Ntaub Ntawv Mining Integration
- Replication
- Qhia Kev Pabcuam thiab
- SQL Server Service Broker
SQL Server 2008 R2
SQL Server 2008 R2 (yav tas los lub npe hu ua SQL Server "Kilimanjaro") muaj qee yam ntxiv nta rau SQL Server 2008,
- PowerPivot rau SharePoint,
- PowerPivot rau Excel,
- Multi-Server Administration thiab Data-Tier Application (cov ntaub ntawv-tier muaj nuj nqi hauv Visual Studio uas tso cai rau ntim cov ntaub ntawv sib tw ua ib feem ntawm daim ntawv thov, ib feem ntawm AMSM (Application thiab Multi-Server Management) uas yog siv rau tswj ntau SQL Servers),
Txoj Kev Txhawb los ntawm Cov Ntawv Tshaj Tawm ntawm SQL Server 2008 R2,
- Scalability thiab Performance
- High Availability (Nco ntsoov)
- Kev them nyiaj yug Virtualization
- Replication
- Kev ruaj ntseg
- Single Instance RDBMS Management
- Daim Ntawv Thov thiab Kev Tswj Xyuas Ntau Yam
- Cov cuab yeej tswj hwm
- Cov cuab yeej tsim kho
- Programmability
- Spatial and Location Services
- Kev Ua Haujlwm Tsis Txaus Siab (StreamInsight)
- Kev Sib Koom Tes
- Kev Sib Koom Tes-Advanced Adapters
- Kev Pabcuam Kev Sib Koom Tes-Kev Hloov Siab Zoo
- Data Warehouse
- Kev Tshuaj Ntsuam Xyuas
- Kev Pabcuam Kev Ntsuam Xyuas-Advanced Analytic Functions
- Data Mining
- Qhia
- Business Intelligence Clients
- Master Data Services
- Kev Sib Koom Tes,
- Kev Pabcuam Kev Sib Koom Tes-Advanced Adapters,
- Kev Pabcuam Kev Sib Koom Tes-Kev Hloov Kho Siab Tshaj Plaws,
- Txuas mus rau lub cav Database Siv Kev Tiv Thaiv Ntxiv,
- Master Data Services,
- StreamInsight,
- ReportBuilder 3.0,
- SQL Server Utility npe UC (Utility Control Point)
SQL Server 2008 R2 muaj tag nrho lwm cov yam ntxwv uas muaj nyob hauv SQL Server 2008 (Database Cav, Kev Pabcuam Kev Tshawb Fawb - Cov Ntaub Ntawv Ntau Yam, Kev Pabcuam Kev Tshawb Fawb - Cov Ntaub Ntawv Mining, Kev Pabcuam Kev Sib Koom, Kev Tshaj Tawm, Kev Tshaj Tawm thiab SQL Server Service Broker).
SQL Server 2008 R2 muaj ntau qhov pom kev zoo dua li SQL Server 2008. Raws li SQL Server 2008 R2 txhawb nqa cov ntaub ntawv tseem ceeb, cov ntaub ntawv nthuav tawm thiab cuam tshuam nrog cov databases uas nyob hauv ntau qhov chaw lub cev. Nws tsis yog tag nrho cov khoom tshiab. Yooj yim, nws txoj kev txhawb nqa rau kev tswj hwm cov ntaub ntawv faib tawm yog siab.
