读书笔记——Microsoft SQL Server 2005 Express Edition For Dummies

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