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
Logon Trigger Execution Guidelines
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 compliance enabled Option
How to: Connect to SQL Server from Windows Vista
Back to Top
Updated Conceptual and Task Topics
Administration
Before Installing Failover Clustering
Configuring Linked Servers for Delegation
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)
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
Limitations on Database Snapshots
Typical Uses of Database Snapshots
Reverting to a Database Snapshot
Back to Top
International Considerations
Back to Top
Maintenance Plans
How to: Create a Maintenance Plan
How to: Start the Maintenance Plan Wizard (SQL Server Management Studio)
Back to Top
Modules (Stored Procedures, Triggers, and User-Defined Functions)
Getting Information About DDL Triggers
Back to Top
Monitoring and Tuning Performance
Audit Login Failed 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
How to: Create Identical Symmetric Keys on Two Servers
Security Considerations for Databases and Database Applications
Back to Top
Showplan Operators
Bookmark Lookup Showplan Operator
Clustered Index Seek Showplan Operator
Back to Top
Tables, Views, and Indexes
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
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)
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