Datasheet

SQL Server 2000 – Particulars and History
13
System/Subsystem Description Editions
Full-Text Search This is an optional part of the main installation. If you
want this functionality, you need to actively choose it
– it's not installed by default. Full-Text Search
provides the functionality to support more robust
word lookups. If you've used an Internet search
engine and been left in awe of the words and phrases
that you can find, Full-Text Search is the tool for you.
It ranges from being able to quickly locate small
phrases in large bodies of text to being able to tell that
"drink" is pretty much the same word as "drunk" or
that "swam" is just the past tense of that word "swim"
you were looking for. This one is not available in the
Personal version (Win 9x) of SQL Server. We'll look
at it extensively in Chapter 26.
Personal
(except Win 9x)
Standard
Developer
Enterprise
English Query Featured in Chapter 27, English Query (EQ) allows
you to develop applications for even the most non-
technical of users. EQ allows users to ask questions or
give commands in plain English and have them
translated into a query that's usable by SQL Server. A
great tool, but keep in mind that this is a completely
separate installation from the rest of SQL Server.
Personal
Standard
Developer
Enterprise
Analysis Services
Yet another tool that isn't part of the main
installation, but gives great extras to the product.
Analysis Services comprises of OLAP (On Line
Analytical Processing), data warehousing, and data
mining tools. It's something that many companies
try to do from their main server – we'll look into
why that's a mistake and how to make use of SQL
Server's Analysis Services in detail in Chapter 25.
The editions listed on the right all support OLAP,
although only Enterprise and Developer have the full
Analysis Services functionality. The Standard and
Personal editions only contain the main functionality,
which consists of Analysis Services itself, custom
rollups, data mining, and actions (end user operation
on data). Additionally, Analysis Services can only be
installed on Windows NT/2000.
Personal
Standard
Developer
Enterprise
Replication This function allows data to be replicated to another
SQL Server instance, usually found on another
server as part of a recovery strategy, or to a remote
server in another physical location, to reduce data
transfer traffic. Replication is covered in Chapter 23.
Desktop Engine
Personal
Standard
Developer
Enterprise
Table continued on following page