Database Engine: New and Updated Topics (31 October 2008)
In the 31 October 2008 release of SQL Server 2008 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
New Conceptual and Task Topics
Database Mirroring Operating Modes
How to: Alter the List of Registered Word Breakers and Filters (Transact-SQL)
How to: Create a Database Schema
How to: Enable or Disable a Server Network Protocol (SQL Server PowerShell)
How to: View or Change the Default Locations for Data and Log Files (SQL Server Management Studio)
Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
Back to Top
Updated Conceptual and Task Topics
About Bulk Import and Bulk Export Operations
Back Up Database (General Page)
Database Properties (Mirroring Page)
Example: Online Restore of a Read/Write File (Full Recovery Model)
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
max full-text crawl range Option
Performance Counters Collector Type
Performance Tuning and Optimization of Full-Text Indexes
Preparing Data for Bulk Export or Import
Prerequisites, Restrictions, and Recommendations for Database Mirroring
Requirements for CLR User-Defined Aggregates
Setting Server Configuration Options
SQL Server Extended Events Targets
Understanding Sparse File Sizes in Database Snapshots
Understanding SQL Dependencies
Using Secondary Servers for Query Processing
Back to Top
New Reference Topics
+= (String Concatenation) (Transact-SQL)
Scope Resolution Operator (Transact-SQL)
Back to Top
Updated Reference Topics
SQLBrowseConnect (SQL Server Native Client - ODBC)
ALTER DATABASE AUDIT SPECIFICATION (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
ALTER SERVER AUDIT (Transact-SQL)
ALTER SERVER AUDIT SPECIFICATION (Transact-SQL)
ALTER WORKLOAD GROUP (Transact-SQL)
CONNECTIONPROPERTY (Transact-SQL)
CREATE FULLTEXT 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)
RESTORE FILELISTONLY (Transact-SQL)
sp_add_jobschedule (Transact-SQL)
sp_add_schedule (Transact-SQL)
sp_create_plan_guide_from_handle (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)
Back to Top