Language Reference: New and Updated Topics (1 February 2007)

Intrinsic Member Properties (MDX)

Catalog Views (Transact-SQL)

Execution Related Dynamic Management Views and Functions

MSpublications (Transact-SQL)

RESTORE Arguments (Transact-SQL)

sys.dm_clr_appdomains

sys.dm_clr_loaded_assemblies

sys.dm_clr_properties

sys.dm_exec_background_job_queue_stats

sys.dm_exec_background_job_queue

sys.dm_exec_cached_plans

sys.dm_exec_connections

sys.dm_exec_query_optimizer_info

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_fts_index_population

sys.dm_fts_memory_buffers

sys.dm_fts_memory_pools

sys.dm_fts_population_ranges

sys.dm_qn_subscriptions

sys.login_token (Transact-SQL)

sys.sql_dependencies (Transact-SQL)

sys.user_token (Transact-SQL)

sysmergepublications (Transact-SQL)

syspublications (System View) (Transact-SQL)

syspublications (Transact-SQL)

Back to Top

Avg (MDX)

CASE Statement (MDX)

CREATE GLOBAL CUBE Statement (MDX)

CREATE MEMBER Statement (MDX)

CREATE SESSION CUBE Statement (MDX)

Exists (MDX)

Max (MDX)

Median (MDX)

Min (MDX)

Ordinal (MDX)

Properties (MDX)

Rank (MDX)

Sum (MDX)

Back to Top

@@IDENTITY (Transact-SQL)

ALTER ASYMMETRIC KEY (Transact-SQL)

ALTER CERTIFICATE (Transact-SQL)

ALTER DATABASE (Transact-SQL)

ALTER FULLTEXT INDEX (Transact-SQL)

ALTER LOGIN (Transact-SQL)

ALTER TABLE (Transact-SQL)

ALTER TRIGGER (Transact-SQL)

BACKUP (Transact-SQL)

BULK INSERT (Transact-SQL)

column_constraint (Transact-SQL)

computed_column_definition (Transact-SQL)

CREATE DATABASE (Transact-SQL)

CREATE FULLTEXT INDEX (Transact-SQL)

CREATE PROCEDURE (Transact-SQL)

CREATE TABLE (Transact-SQL)

DBCC CHECKDB (Transact-SQL)

DBCC CHECKFILEGROUP (Transact-SQL)

DBCC CHECKTABLE (Transact-SQL)

DBCC FREEPROCCACHE (Transact-SQL)

DBCC FREESYSTEMCACHE

DENY (Transact-SQL)

DISABLE TRIGGER (Transact-SQL)

DROP DATABASE (Transact-SQL)

DROP TABLE (Transact-SQL)

ENABLE TRIGGER (Transact-SQL)

EVENTDATA (Transact-SQL)

fn_my_permissions (Transact-SQL)

GRANT (Transact-SQL)

ISNUMERIC (Transact-SQL)

NULLIF (Transact-SQL)

OBJECT_NAME (Transact-SQL)

OBJECTPROPERTY (Transact-SQL)

OBJECTPROPERTYEX (Transact-SQL)

OPENROWSET (Transact-SQL)

OUTPUT Clause (Transact-SQL)

RESTORE (Transact-SQL)

SCOPE_IDENTITY (Transact-SQL)

sp_add_schedule (Transact-SQL)

sp_addlinkedserver (Transact-SQL)

sp_addmergepublication (Transact-SQL)

sp_addmergepullsubscription (Transact-SQL)

sp_addmergepullsubscription_agent (Transact-SQL)

sp_addmergepushsubscription_agent (Transact-SQL)

sp_addpublication (Transact-SQL)

sp_addpublication_snapshot (Transact-SQL)

sp_addpullsubscription (Transact-SQL)

sp_addpullsubscription_agent (Transact-SQL)

sp_addpushsubscription_agent (Transact-SQL)

sp_attach_db (Transact-SQL)

sp_change_users_login (Transact-SQL)

sp_changemergepublication (Transact-SQL)

sp_changepublication (Transact-SQL)

sp_changepublication_snapshot (Transact-SQL)

sp_detach_db (Transact-SQL)

sp_helpmergepublication (Transact-SQL)

sp_serveroption (Transact-SQL)

sp_settriggerorder (Transact-SQL)

sp_tableoption (Transact-SQL)

sp_tables (Transact-SQL)

sp_trace_setevent (Transact-SQL)

sys.dm_db_missing_index_columns

sys.dm_exec_cursors

sys.dm_exec_plan_attributes

sys.dm_exec_query_plan

sys.dm_exec_sql_text

sysmail_add_principalprofile_sp (Transact-SQL)

sysmail_delete_principalprofile_sp (Transact-SQL)

sysmail_delete_profile_sp (Transact-SQL)

sysmail_help_principalprofile_sp (Transact-SQL)

sysmail_update_principalprofile_sp (Transact-SQL)

Table Hint (Transact-SQL)

table_constraint (Transact-SQL)

UPDATE STATISTICS (Transact-SQL)

Back to Top