Datasheet

⻬ Multi-processors: Running a computer with more than one central pro-
cessing unit (CPU) is a great way to increase performance and through-
put. However, SQL Server 2005 Express only takes advantage of one CPU,
regardless of how many are available.
⻬ Administrative tools: Microsoft offers the excellent SQL Server
Management Studio Express graphical tool to help you monitor and
manage your database. It’s available for free download from Microsoft’s
Web site.
⻬ Visual Studio integration: Although SQL Server 2005 Express is consid-
ered an entry-level product, you’re free to use the full power of Microsoft’s
flagship development platform, Visual Studio. This product is fully inte-
grated with all the SQL Server 2005 database offerings, including Express.
Figure 1-1 shows you what this looks like, in the context of building a C#
class file.
⻬ Full-text searching: This feature helps you index and then query large
blocks of text-based information. Although it’s not present in SQL Server
2005 Express, you will find it in SQL Server 2005 Express with Advanced
Services. Regardless of which version you use, your application can still
store and work with this kind of information; the method you use might
vary, however.
Figure 1-1:
SQL Server
2005
Express
information
available
from inside
Visual
Studio.
13
Chapter 1: SQL Server 2005 Express Overview
05_599275 ch01.qxp 6/1/06 9:08 PM Page 13