Home
Microsoft SQL Server
  - System tables
  - Procedure
  - Views
  - DMV
  - Functions
DigiMailing
Contact

Audit Security
Change Data Capture Related dm_audit_actions
dm_audit_class_type_map

Broker Service Broker dm_broker_activated_tasks
dm_broker_connections
dm_broker_forwarded_messages
dm_broker_queue_monitors

Cdc
Change Data Capture dm_cdc_errors
dm_cdc_log_scan_sessions

Clr
Common Language Runtime dm_clr_appdomains
dm_clr_loaded_assemblies
dm_clr_properties
dm_clr_tasks


Security
*dm_cryptographic_provider_sessions *dm_cryptographic_provider_algorithms *dm_cryptographic_provider_keys dm_cryptographic_provider_properties
dm_database_encryption_keys

Database
Database
dm_db_file_space_usage
dm_db_index_usage_stats
dm_db_mirroring_auto_page_repair
dm_db_mirroring_connections
dm_db_mirroring_past_actions
dm_db_missing_index_details
dm_db_missing_index_groups
dm_db_missing_index_group_stats
dm_db_partition_stats
dm_db_persisted_sku_features
dm_db_script_level
dm_db_session_space_usage
dm_db_task_space_usage

Exec
Execution
*dm_cached_plan_depent_objects * *dm_exec_plan_attributes *dm_exec_query_plan *dm_exec_query_stats dm_exec_sql_text *dm_exec_text_query_plan *dm_exec_xml_handles dm_exec_background_job_queue
dm_exec_background_job_queue_stats
dm_exec_cached_plans
dm_exec_connections
dm_exec_procedure_stats
dm_exec_query_memory_grants
dm_exec_query_optimizer_info
dm_exec_query_resource_semaphores
dm_exec_query_stats
dm_exec_query_transformation_stats
dm_exec_requests
dm_exec_sessions
dm_exec_trigger_stats

Filestream
Filestreams
dm_filestream_file_io_handles
dm_filestream_file_io_requests

Fts
Full-Text Search
dm_fts_active_catalogs
dm_fts_fdhosts
dm_fts_index_population
dm_fts_memory_buffers
dm_fts_memory_pools
dm_fts_outstanding_batches
dm_fts_population_ranges

IO
I/O
*dm_io_cluster_shared_drives dm_io_backup_tapes
dm_io_cluster_shared_drives
dm_io_pending_io_requests

OS
Operating Systems
dm_os_buffer_descriptors
dm_os_child_instances
dm_os_cluster_nodes
dm_os_dispatchers
dm_os_dispatcher_pools
dm_os_hosts
dm_os_latch_stats
dm_os_loaded_modules
dm_os_memory_allocations
dm_os_memory_brokers
dm_os_memory_cache_clock_hands
dm_os_memory_cache_counters
dm_os_memory_cache_entries
dm_os_memory_cache_hash_tables
dm_os_memory_clerks
dm_os_memory_nodes
dm_os_memory_node_access_stats
dm_os_memory_objects
dm_os_memory_pools
dm_os_nodes
dm_os_performance_counters
dm_os_process_memory
dm_os_ring_buffers
dm_os_schedulers
dm_os_spinlock_stats
dm_os_stacks
dm_os_sublatches
dm_os_sys_info
dm_os_sys_memory
dm_os_tasks
dm_os_threads
dm_os_virtual_address_dump
dm_os_waiting_tasks
dm_os_wait_stats
dm_os_workers
dm_os_worker_local_storage

Qn
Query Notifications
dm_qn_subscriptions

Replication
Replication
dm_repl_articles
dm_repl_schemas
dm_repl_tranhash
dm_repl_traninfo

Resource govener
Resource Govener
dm_resource_governor_configuration
dm_resource_governor_resource_pools
dm_resource_governor_workload_groups


dm_server_audit_status

Transaction
Transactional
dm_tran_active_snapshot_database_transactions
dm_tran_active_transactions
dm_tran_commit_table
dm_tran_current_snapshot
dm_tran_current_transaction
dm_tran_database_transactions
dm_tran_locks
dm_tran_session_transactions
dm_tran_top_version_generators
dm_tran_transactions_snapshot
dm_tran_version_store

XE
Extended Events
dm_xe_map_values
dm_xe_objects
dm_xe_object_columns
dm_xe_packages
dm_xe_sessions
dm_xe_session_events
dm_xe_session_event_actions
dm_xe_session_object_columns
dm_xe_session_targets

Nieuws

Create all your missing indexes
Converting datetime field
Start MSSQL Server Profiler at time
Replicating MSSQL Server views
Exploring Microsoft Sharepoint
The OLE DB provider "SQLNCLI10" for linked server indicates.
Mobile solar charger
Oracle to SQL Server replication
Cannot insert the value NULL into column
Undocumented Microsoft SQL Server 2008
VMware
Zoekmachine optimalisatie
SQL Servers hidden objects
FckEditor
Flash in Ajax
De hype die AJAX heet
Barcode scannen
MySQL; Gratis, makkelijk en snel!
PHP
sIFR; de combinatie tussen HTML en Flash