Database Engine: New and Updated Topics (1 February 2007)

In the 12 December 2006 release of SQL Server Books Online, the following topics have either been added or updated.

Topic Categories

New Conceptual and Task Topics

Updated Conceptual and Task Topics

New Reference Topics

Updated Reference Topics

Updated Managed Reference Topics

New Conceptual and Task Topics

Key Lookup Showplan Operator

Logon Trigger Execution Guidelines

Logon Triggers

Storing Decimal Data As Variable Length

Troubleshooting Database Mail: Send mail from remote server when troubleshooting local server

Maintenance Plans

How to: Add or Modify Maintenance Plan Subplan Schedules

How to: Create Multiserver Maintenance Plans

How to: Migrate SQL Server 2000 Database Maintenance Plans

Security

Common Criteria Certification

common criteria compliance enabled Option

FIPS 140-2 Compliance

How to: Connect to SQL Server from Windows Vista

Security Standards Compliance

Back to Top

Updated Conceptual and Task Topics

Administration

Before Installing Failover Clustering

Configuring Linked Servers for Delegation

Configuring Virtual Memory

Creating a Multiserver Environment

How to: Add or Remove Nodes in a SQL Server 2005 Failover Cluster (Setup)

How to: Create a New SQL Server 2005 Failover Cluster (Setup)

How to: Enlist a Target Server to a Master Server (SQL Server Management Studio)

Setting Server Configuration Options

Back to Top

Backup and Restore

Backup and Restore in Large Mission-Critical Environments

Introduction to Backup and Restore Strategies in SQL Server

Back to Top

Data Manipulation Language (DML)

Identifiers

In-Row Data

Limiting Result Sets by Using TABLESAMPLE

Back to Top

Database Mirroring

Database Mirroring and Cross-Database Transactions

Prerequisites and Recommendations for Database Mirroring

Back to Top

Database Snapshots

Dropping a Database Snapshot

How Database Snapshots Work

Limitations on Database Snapshots

Typical Uses of Database Snapshots

Reverting to a Database Snapshot

Back to Top

International Considerations

Supplementary Characters

Back to Top

Maintenance Plans

How to: Create a Maintenance Plan

How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)

Maintenance Plan Wizard

Maintenance Plans

Back to Top

Modules (Stored Procedures, Triggers, and User-Defined Functions)

Designing DDL Triggers

Getting Information About DDL Triggers

Back to Top

Monitoring and Tuning Performance

Audit Login Event Class

Audit Login Failed Event Class

Audit Logout Event Class

Degree of Parallelism (7.0 Insert) Event Class

Performance Statistics Event Class

Viewing and Analyzing Traces with SQL Server Profiler

Back to Top

Security

db_datareader

How to: Create Identical Symmetric Keys on Two Servers

Security Considerations for Databases and Database Applications

Security for Linked Servers

User-Schema Separation

Back to Top

Showplan Operators

Bookmark Lookup Showplan Operator

Clustered Index Seek Showplan Operator

Back to Top

Tables, Views, and Indexes

Creating Indexed Views

Index Statistics

Planning Guidelines for Partitioned Tables and Indexes

Querying Data and Metadata from Partitioned Tables and Indexes

Transferring Data Efficiently by Using Partition Switching

Back to Top

Transactions

Understanding Row Versioning-Based Isolation Levels

Back to Top

Transferring Data

Basic Guidelines for Bulk Importing Data

Controlling Constraint Checking by Bulk Import Operations

Configuring Log Shipping

Detaching and Attaching Databases

Optimizing Bulk Import Performance

Transferring Data Efficiently by Using Partition Switching

Back to Top

New Reference Topics

Error Messages: New and Updated Topics (1 February 2007)

Language Reference: New and Updated Topics (1 February 2007)

sqllogship Application

Back to Top

Updated Reference Topics

Language Reference: New and Updated Topics (1 February 2007)

Back to Top

Updated Managed Reference Topics

Microsoft.SqlServer.Management.Smo.ApplicationRoleCollection

Microsoft.SqlServer.Management.Smo.AsymmetricKeyCollection

Microsoft.SqlServer.Management.Smo.BackupDeviceCollection

Microsoft.SqlServer.Management.Smo.CertificateCollection

Microsoft.SqlServer.Management.Smo.ConfigPropertyCollection

Microsoft.SqlServer.Management.Smo.Configuration

Microsoft.SqlServer.Management.Smo.CredentialCollection

Microsoft.SqlServer.Management.Smo.DatabaseCollection

Microsoft.SqlServer.Management.Smo.DatabaseDdlTriggerCollection

Microsoft.SqlServer.Management.Smo.DatabaseMirroringPayload

Microsoft.SqlServer.Management.Smo.DatabaseRole

Microsoft.SqlServer.Management.Smo.DatabaseRoleCollection

Microsoft.SqlServer.Management.Smo.DefaultCollection

Microsoft.SqlServer.Management.Smo.EndpointCollection

Microsoft.SqlServer.Management.Smo.ExtendedStoredProcedureCollection

Microsoft.SqlServer.Management.Smo.FullTextCatalogCollection

Microsoft.SqlServer.Management.Smo.HttpProtocol

Microsoft.SqlServer.Management.Smo.Information

Microsoft.SqlServer.Management.Smo.LanguageCollection

Microsoft.SqlServer.Management.Smo.LinkedServerCollection

Microsoft.SqlServer.Management.Smo.LinkedServerLoginCollection

Microsoft.SqlServer.Management.Smo.LoginCollection

Microsoft.SqlServer.Management.Smo.ObjectRenamedEventArgs

Microsoft.SqlServer.Management.Smo.OleDbProviderSettingsCollection

Microsoft.SqlServer.Management.Smo.PartitionFunctionCollection

Microsoft.SqlServer.Management.Smo.PartitionSchemeCollection

Microsoft.SqlServer.Management.Smo.RuleCollection

Microsoft.SqlServer.Management.Smo.SchemaCollection

Microsoft.SqlServer.Management.Smo.ScriptOption

Microsoft.SqlServer.Management.Smo.ServerDdlTriggerCollection

Microsoft.SqlServer.Management.Smo.ServerRoleCollection

Microsoft.SqlServer.Management.Smo.ServiceBrokerPayload

Microsoft.SqlServer.Management.Smo.SmoCollectionBase

Microsoft.SqlServer.Management.Smo.SoapPayload

Microsoft.SqlServer.Management.Smo.SoapPayloadMethod

Microsoft.SqlServer.Management.Smo.SqlAssemblyCollection

Microsoft.SqlServer.Management.Smo.SqlAssemblyFileCollection

Microsoft.SqlServer.Management.Smo.StatisticCollection

Microsoft.SqlServer.Management.Smo.StoredProcedureCollection

Microsoft.SqlServer.Management.Smo.SynonymCollection

Microsoft.SqlServer.Management.Smo.TableCollection

Microsoft.SqlServer.Management.Smo.TriggerCollection

Microsoft.SqlServer.Management.Smo.UrnCollection

Microsoft.SqlServer.Management.Smo.UserCollection

Microsoft.SqlServer.Management.Smo.UserDefinedAggregateCollection

Microsoft.SqlServer.Management.Smo.UserDefinedDataTypeCollection

Microsoft.SqlServer.Management.Smo.UserDefinedFunctionCollection

Microsoft.SqlServer.Management.Smo.UserDefinedTypeCollection

Microsoft.SqlServer.Management.Smo.ViewCollection

Microsoft.SqlServer.Management.Smo.XmlSchemaCollectionCollection

Microsoft.SqlServer.Management.Smo.Agent.Job

Microsoft.SqlServer.Management.Smo.Agent.JobCollection

Microsoft.SqlServer.Management.Smo.Agent.OperatorCollection

Microsoft.SqlServer.Management.Smo.Agent.ProxyAccountCollection

Microsoft.SqlServer.Management.Smo.Agent.TargetServerCollection

Microsoft.SqlServer.Management.Smo.Agent.TargetServerGroupCollection

Microsoft.SqlServer.Management.Smo.Broker.BrokerServiceCollection

Microsoft.SqlServer.Management.Smo.Broker.RemoteServiceBindingCollection

Microsoft.SqlServer.Management.Smo.Broker.ServiceContractCollection

Microsoft.SqlServer.Management.Smo.Broker.ServiceQueueCollection

Microsoft.SqlServer.Management.Smo.Broker.ServiceRouteCollection

Microsoft.SqlServer.Management.Smo.Mail.ConfigurationValueCollection

Microsoft.SqlServer.Management.Smo.Mail.MailAccountCollection

Microsoft.SqlServer.Management.Smo.Mail.MailProfileCollection

Microsoft.SqlServer.Management.Smo.Mail.MailServerCollection

Back to Top

See Also

Concepts

New and Updated Books Online Topics (1 February 2007)
Database Engine: New and Updated Topics (17 July 2006)
Database Engine: New and Updated Topics (14 April 2006)
What's New in SQL Server 2005 SP2

Help and Information

Getting SQL Server 2005 Assistance