Export (0) Print
Expand All

Database Engine: New and Updated Topics (31 October 2008)

SQL Server 2008

In the 31 October 2008 release of SQL Server 2008 Books Online, the following topics have either been added or updated.

About Bulk Import and Bulk Export Operations

Back Up Database (General Page)

clr enabled Option

Copy-Only Backups

Creating an Assembly

Data Collector Logging

Database Properties (Mirroring Page)

Example: Online Restore of a Read/Write File (Full Recovery Model)

Full-Text Search Filters

Generic SQL Trace Collector Type

Generic T-SQL Query Collector Type

How to: Add a Collection Item to a Collection Set

How to: Back Up a Database (SQL Server Management Studio)

How to: Back Up a Transaction Log (SQL Server Management Studio)

How to: Create a Custom Collection Set That Uses the Generic T-SQL Query Collector Type

How to: Create a Differential Database Backup (SQL Server Management Studio)

How to: Edit a Thesaurus File (Full-Text Search)

How to: Enable Log Shipping (SQL Server Management Studio)

How to: Load Licensed Third-Party Word Breakers

How to: Manually Fail Over a Database Mirroring Session (SQL Server Management Studio)

How to: Restore a Database to a Marked Transaction (SQL Server Management Studio)

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

How to: Restore the master Database (Transact-SQL)

Invoking CLR User-Defined Aggregate Functions

Log Shipping Overview

Mapping CLR Parameter Data

max full-text crawl range Option

Moving System Databases

Performance Counters Collector Type

Performance Tuning and Optimization of Full-Text Indexes

Preparing Data for Bulk Export or Import

Query Activity Collector Type

Prerequisites, Restrictions, and Recommendations for Database Mirroring

Query Activity Collector Type

Requirements for CLR User-Defined Aggregates

Setting Server Configuration Options

SQL Server Extended Events Targets

System Data Collection Sets

The Management Data Warehouse

Understanding Sparse File Sizes in Database Snapshots

Understanding SQL Dependencies

Using Secondary Servers for Query Processing

Using Sparse Columns

Word Breakers and Stemmers

Arrow icon used with Back to Top linkBack to Top

SQLBrowseConnect (SQL Server Native Client - ODBC)

ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL)

ALTER FULLTEXT CATALOG (Transact-SQL)

ALTER INDEX (Transact-SQL)

ALTER SERVER AUDIT (Transact-SQL)

ALTER SERVER AUDIT SPECIFICATION (Transact-SQL)

ALTER WORKLOAD GROUP (Transact-SQL)

BACKUP (Transact-SQL)

bcp Utility

BULK INSERT (Transact-SQL)

CONNECTIONPROPERTY (Transact-SQL)

CONTAINS (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

CREATE INDEX (Transact-SQL)

CREATE SERVER AUDIT SPECIFICATION (Transact-SQL)

CREATE WORKLOAD GROUP (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC UPDATEUSAGE (Transact-SQL)

DROP SERVER AUDIT (Transact-SQL)

DROP SERVER AUDIT SPECIFICATION (Transact-SQL)

OPENROWSET (Transact-SQL)

RESTORE FILELISTONLY (Transact-SQL)

sp_add_jobschedule (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_create_plan_guide_from_handle (Transact-SQL)

sp_createstats (Transact-SQL)

sp_fulltext_catalog (Transact-SQL)

sp_fulltext_service (Transact-SQL)

sp_help_fulltext_catalogs (Transact-SQL)

sp_help_fulltext_catalogs_cursor (Transact-SQL)

sp_help_fulltext_system_components (Transact-SQL)

sp_update_schedule (Transact-SQL)

sys.dm_db_index_physical_stats (Transact-SQL)

sys.dm_exec_connections (Transact-SQL)

sys.dm_fts_index_keywords_by_document (Transact-SQL)

sys.dm_fts_population_ranges (Transact-SQL)

sys.dm_os_wait_stats (Transact-SQL)

sys.dm_sql_referenced_entities (Transact-SQL)

sys.dm_sql_referencing_entities (Transact-SQL)

sys.dm_xe_map_values (Transact-SQL)

sys.dm_xe_object_columns (Transact-SQL)

sys.dm_xe_objects (Transact-SQL)

sys.dm_xe_packages (Transact-SQL)

sys.dm_xe_session_event_actions (Transact-SQL)

sys.dm_xe_session_events (Transact-SQL)

sys.dm_xe_session_object_columns (Transact-SQL)

sys.dm_xe_session_targets (Transact-SQL)

sys.dm_xe_sessions (Transact-SQL)

sys.fulltext_indexes (Transact-SQL)

sys.sql_expression_dependencies (Transact-SQL)

syscollector_collection_items (Transact-SQL)

syscollector_collection_sets (Transact-SQL)

syscollector_collector_types (Transact-SQL)

syscollector_config_store (Transact-SQL)

syscollector_execution_log (Transact-SQL)

syscollector_execution_log_full (Transact-SQL)

syscollector_execution_stats (Transact-SQL)

Arrow icon used with Back to Top linkBack to Top

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft