Database Engine: New and Updated Topics (14 April 2006)

New: 14 April 2006

In the 14 April 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

Updated Reference Topics

New Conceptual and Task Topics

Administration

Connection Retry Algorithm (for TCP/IP Connections)

How to: Determine Whether the Database Engine Is Installed and Started

Backup and Restore

Recovery Models for System Databases

Database Mirroring

Database Mirroring and Cross-Database Transactions

How to: Add or Replace a Database Mirroring Witness (SQL Server Management Studio)

How to: Launch Database Mirroring Monitor

How to: Remove the Witness from a Database Mirroring Session (SQL Server Management Studio)

Making the Initial Connection to a Database Mirroring Session

Monitoring Mirroring Status

Reconnecting to a Database Mirroring Session

Using Warning Thresholds and Alerts on Mirroring Performance Metrics

Metadata

Internal Tables

Managing Metadata When Making a Database Available on Another Server Instance

Options

Replication XPs Option

Query Notification

QN:Dynamics Event Class

QN:Parameter Table Event Class

QN:Subscription Event Class

QN:Template Event Class

Query Notifications Event Category

Security

How to: Change the Password of the Accounts Used by SQL Server

Schemas

IDs and SIDs

SQL Server Agent

Choosing the Right SQL Server Agent Service Account for Multiserver Environments

How to: Create a WMI Event Alert (SQL Server Management Studio)

Setting Encryption Options on Target Servers

Troubleshooting Multiserver Jobs That Use Proxies

Troubleshooting

Troubleshooting Insufficient Data Disk Space

Troubleshooting Protocol Errors Upon Database Engine Startup

Troubleshooting: Login failed for user 'x'

Back to Top

Tutorials

Writing Transact-SQL Statements Tutorial

Visual Database Tools

How to: Change the Font Color, Size, and Style in Diagrams (Visual Database Tools)

Updated Conceptual and Task Topics

Administration

How to: Configure a Firewall for SQL Server Access

How to: Start an Instance of SQL Server (net Commands)

SQL Server Browser Service

Using a Dedicated Administrator Connection

Backup and Restore

Considerations for Backing Up and Restoring System Databases

Back Up Database Task (Maintenance Plan)

Backup Devices

Choosing the Recovery Model for a Database

Full File Backups

Optimizing Backup and Restore Performance in SQL Server

How to: Restore a Database to a New Location and Name (Transact-SQL)

Prerequisites and Recommendations for Database Mirroring

Considerations for Restoring the master Database

Connecting to the SQL Server Database Engine

Identifying a Data Source by Using a Linked Server Name

Oracle Provider for OLE DB

Troubleshooting Database Engine Connectivity

Databases, Files, and Filegroups

Capacity Planning for tempdb

Identifiers

Limitations on Database Snapshots

Log File Auto Grow Event Class

Moving System Databases

Overview of Scalable Shared Databases

Considerations for Rebuilding the master Database

Resource Database

Shrinking a Database

tempdb Database

Transaction Log Physical Architecture

Troubleshooting a Full Transaction Log (Error 9002)

Transaction Log Truncation

Database Mirroring

Additional Sources of Information about a Mirrored Database

Database Mirroring Endpoint

Database Mirroring Sessions

Forced Service (with Possible Data Loss)

Mirroring States

Overview of Database Mirroring Setup

Possible Failures During Database Mirroring

Replication and Database Mirroring

The Impact of a Stale Failover Partner Name

Troubleshooting Database Mirroring Setup

Data Manipulation Language

Comparing DATEADD and DATEDIFF

Comparing DATEPART and DATENAME

Deleting Rows by Using DELETE

Limiting Result Sets by Using TABLESAMPLE

Using APPLY

Using Cross Joins

Event Notification

Data File Auto Shrink Event Class

DDL Event Groups for Use with Event Notifications

DDL Events for Use with DDL Triggers

DDL Events for Use with Event Notifications

DDL_EVENTS

Designing Event Notifications

Event Groups for Use with DDL Triggers

Trace Events for Use with Event Notifications

TRC_ALL_EVENTS

WMI Provider for Server Events Classes and Properties

Memory

Enabling Memory Support for Over 4 GB of Physical Memory

Hot Add Memory

How to: Enable the Lock Pages in Memory Option (Windows)

How to: Map TCP/IP Ports to NUMA Nodes

Memory Architecture

NUMA Scenarios

Using AWE

Metadata

Querying the SQL Server System Catalog FAQ

Troubleshooting Metadata Visibility

VIEW DEFINITION Permission

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

DML Triggers in the AdventureWorks Sample Database

Executing User-defined Functions (Database Engine)

How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)

Implementing DDL Triggers

Log Shipping Tables and Stored Procedures

Understanding DDL Triggers

Options

Ad Hoc Distributed Queries Option

allow updates Option

clr enabled Option

Server Memory Options

SET Options That Affect Results

Setting Server Configuration Options

transform noise words Option

Query Notification

Creating a Query for Notification

Query Notification Permissions

Using SQL Trace to Troubleshoot Query Notifications

Showplan

Analyzing Queries with SHOWPLAN Results in SQL Server Profiler

Assert Showplan Operator

SQL Server Agent

Alerting Operators

Creating a Multiserver Environment

Creating SQL Server Agent Proxies

How to: Create a Proxy (SQL Server Management Studio)

How to: Create a SQL Server Agent Job (Transact-SQL)

How to: Create a SQL Server Agent Proxy (Transact-SQL)

Maintenance Plan Wizard

Running Jobs

Service Account Types Supported for SQL Server Agent

Using Tokens in Job Steps

SQL Server Management Studio

Database Properties (Mirroring Page)

Database Properties (Transaction Log Shipping Page)

Database Properties Page (General)

Database User (General Page)

Generate SQL Server Scripts Wizard (Output Option Page)

How to: Add an External Tool to the Tools Menu (SQL Server Management Studio)

How to: Use Source Control with SQL Server Management Studio

Job Step Properties / New Job Step (General Page)

Maintenance Cleanup Task (Maintenance Plan)

Maintenance Plan Wizard (Select Target Servers Page)

Mirror Server Instance (Configure Database Mirroring Security Wizard)

Tables, Views, and Indexes

About the Missing Indexes Feature

Cascading Referential Integrity Constraints

Creating and Modifying Identifier Columns

Creating Indexed Views

Designing and Implementing Views

Disk Space Requirements for Index DDL Operations

Guidelines for Performing Online Index Operations

Implementing User-defined Types

Performing Operations on User-defined Types

Using Synonyms (Database Engine)

Using uniqueidentifier Data

Transactions

Transact-SQL Statements Allowed in Transactions

Using TRY...CATCH in Transact-SQL

Transferring Data

bcp Utility

Guidelines for Optimizing Bulk Import

Preparing Data for Bulk Export or Import

Transferring Data Efficiently by Using Partition Switching

Replication and Log Shipping

Using the Copy Database Wizard

Troubleshooting

Troubleshooting a Full Transaction Log (Error 9002)

Troubleshooting Database Engine Connectivity

Troubleshooting Database Mirroring Setup

Troubleshooting Metadata Visibility

Visual Database Tools

How to: Clear Query Results (Visual Database Tools)

How to: Create Outer Joins (Visual Database Tools)

How to: Create Queries (Visual Database Tools)

How to: Modify Column Identity Properties (Visual Database Tools)

How to: Set Up Database Diagram Designer (Visual Database Tools)

Working with SQL Server 2000 Diagrams

XML

Guidelines and Limitations in Using XML Schema Collections on the Server

Sample XML Format Files

Back to Top

Updated Reference Topics

Handling SMO Exceptions

Language Reference: New and Updated Topics (14 April 2006)

Using WQL with the WMI Provider for Server Events

Back to Top