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
Reconnecting to a Database Mirroring Session
Using Warning Thresholds and Alerts on Mirroring Performance Metrics
Metadata
Managing Metadata When Making a Database Available on Another Server Instance
Options
Query Notification
QN:Parameter Table Event Class
Query Notifications Event Category
Security
How to: Change the Password of the Accounts Used by SQL Server
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)
Using a Dedicated Administrator Connection
Backup and Restore
Considerations for Backing Up and Restoring System Databases
Back Up Database Task (Maintenance Plan)
Choosing the Recovery Model for a Database
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
Troubleshooting Database Engine Connectivity
Databases, Files, and Filegroups
Limitations on Database Snapshots
Log File Auto Grow Event Class
Overview of Scalable Shared Databases
Considerations for Rebuilding the master Database
Transaction Log Physical Architecture
Troubleshooting a Full Transaction Log (Error 9002)
Database Mirroring
Additional Sources of Information about a Mirrored Database
Forced Service (with Possible Data Loss)
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
Limiting Result Sets by Using TABLESAMPLE
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
Event Groups for Use with DDL Triggers
Trace Events for Use with Event Notifications
WMI Provider for Server Events Classes and Properties
Memory
Enabling Memory Support for Over 4 GB of Physical Memory
How to: Enable the Lock Pages in Memory Option (Windows)
How to: Map TCP/IP Ports to NUMA Nodes
Metadata
Querying the SQL Server System Catalog FAQ
Troubleshooting Metadata Visibility
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)
Log Shipping Tables and Stored Procedures
Options
Ad Hoc Distributed Queries Option
SET Options That Affect Results
Setting Server Configuration Options
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
SQL Server Agent
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)
Service Account Types Supported for SQL Server Agent
SQL Server Management Studio
Database Properties (Mirroring Page)
Database Properties (Transaction Log Shipping Page)
Database Properties Page (General)
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
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)
Transactions
Transact-SQL Statements Allowed in Transactions
Using TRY...CATCH in Transact-SQL
Transferring Data
Guidelines for Optimizing Bulk Import
Preparing Data for Bulk Export or Import
Transferring Data Efficiently by Using Partition Switching
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
Back to Top
Updated Reference Topics
Language Reference: New and Updated Topics (14 April 2006)
Using WQL with the WMI Provider for Server Events
Back to Top