Microsoft SQL Server 2005 Express Edition For Dummies
By Robert Schneider
Chapter 1 SQL Server 2005 Express Overview
【单词】
breed | 品种 | As more time passed, a new breed of database companies arose. |
tabular | 表格式的 | Relational database are particularly well designed for storing information in tabular format. |
fray | 磨损 | Microsoft also entered the relational database fray some years... |
intimidate | 胁迫 | |
siblings | 兄弟姐妹 | |
accolade | 赞美 | On top of that accolade, it's also free to download. |
seasoned | 经验丰富的 | seasoned or brand-new |
sturdy | 强健的 | sturdy database |
robust | 精力充沛的 | |
crunched | This is especially true if your environment sports massive volumes of data that need to be crunched to come up with recognizable patterns. | |
communiques | 公报 | You can then integrate and deliver these communiques through a series of different presentation technologies. 【Report Server】 |
finicky | 过分讲究的 | |
curious | 好奇的 | |
disparate | 异构的 | |
react | 反抗,起反作用 | |
replication | du-plication,ap-plication | |
cornerstone | 基础,墙角石 | |
inventory | 财产清单 | |
ensconce | 安置 | information safely ensconced in SQL Server 2005 Express database. |
ponder | 考虑 | contemplate |
impact | 影响 | com-pact |
consigned | 委托 | |
elective | 选择 | You have a wide variety of electives when building a solution that stores its information in this database. |
inclined to | 倾向于 | trend |
potent | 有效的 | potent tools |
tremendous | 极大的 | |
steeper | 陡峭的 | steeper learning curve |
intuitive | 直观的 |
【SQL Server 2005 Express 的限制】
- Does NOT take advantage of any more than 1GB of RAM.
- Database size can NOT be bigger than 4GB.
- Only takes advantage of 1 CPU, regardless of how many are available.
- No Full-text searching.
- Does NOT offer the capabilities -- offers numerous technologies to help keep your database up and running at all time.
- No Analysis Services
- No Integration Services
- Notification Services
- Recovery Strategy
- No SQL Server Agent
【Where does SSE 2005 Work Best?】
- SOHO
- For example, you might store details about all the individual transactions that your organization performs, and then use BI (business intelligence) or other data analysis tools to help identify trends from your sales results.
- Distributed Enterprise -- Replication Architecture
- ISV / OEM