M$ is putting out more content for the server in this SP.
Entire text is at http://tinyurl.com/ygkvzz
Below is just for the database engine:
Database Engine
* Maintenance plans are now supported by the SQL Server Database
Services installation. Before SP2, you were required to install SQL
Server 2005 Integration Services (SSIS) to run maintenance plans on a
server-only installation.
* Maintenance plans now support multiserver environments, logging to
remote servers, and multiple schedules. For more information, see How
to: Create Multiserver Maintenance Plans How to: Create a Maintenance
Plan and How to: Add or Modify Maintenance Plan Subplan Schedules.
* Added new functionality in the SQL Server 2005 Enterprise Edition
to provide an alternate storage format that can be used to minimize the
disk space needed to store existing decimal and numeric data types. No
application changes area are required to use its benefits. This new
storage format, known as vardecimal storage format, stores decimal and
numeric data as variable length columns and can be enabled or disabled
at a table level on new or existing tables. If you have declared a
decimal or numeric column with high precision but most values do not
require it, you can potentially save the disk space needed to store the
table. A new stored procedure is provided to estimate the reduction in
average row size with the new storage format.
* Added logon triggers and a common criteria compliance enabled
Option for sp_configure to support common criteria in the SQL Server
2005 Enterprise Edition.
* The sqllogship application is now supported. This application
performs a backup, copy, or restore operation and associated clean-up
tasks for a log shipping configuration.
* Plan cache improvements that provide improved system performance,
better use of the available physical memory for database pages, and the
ability to return text XML query plans that contain an XML nesting level
greater than or equal to 128 by using the new
sys.dm_exec_text_query_plan table-valued function.
* SMO for Relational Engine Features
o Table.CheckIdentityValue() correctly generates the schema
name for the fully qualified object name.
o Column.AddDefaultConstraint() works against table columns
for SQL Server 2000 database instances.
Stephen Russell
.NET Developer/DBA
Gate Gourmet
c/o Ciber
Forum III
1770 Kirby Parkway, Suite 427
Memphis, TN 38138
901.752.6577 Ext. 6736
Direct: 901.752.6736
Toll Free: 1.800.221.1640 Ext. 6736
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
