clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591659 fiddles created (45712 in the last week).

SELECT top 10 percent * FROM sys.databases where name not like '%fiddle%' ORDER BY database_id --OFFSET 0 ROWS --FETCH NEXT (SELECT CAST(CEILING((COUNT(*) * 10.0/100.0)) as int) FROM sys.databases) ROWS ONLY;
name database_id source_database_id owner_sid create_date compatibility_level collation_name user_access user_access_desc is_read_only is_auto_close_on is_auto_shrink_on state state_desc is_in_standby is_cleanly_shutdown is_supplemental_logging_enabled snapshot_isolation_state snapshot_isolation_state_desc is_read_committed_snapshot_on recovery_model recovery_model_desc page_verify_option page_verify_option_desc is_auto_create_stats_on is_auto_create_stats_incremental_on is_auto_update_stats_on is_auto_update_stats_async_on is_ansi_null_default_on is_ansi_nulls_on is_ansi_padding_on is_ansi_warnings_on is_arithabort_on is_concat_null_yields_null_on is_numeric_roundabort_on is_quoted_identifier_on is_recursive_triggers_on is_cursor_close_on_commit_on is_local_cursor_default is_fulltext_enabled is_trustworthy_on is_db_chaining_on is_parameterization_forced is_master_key_encrypted_by_server is_query_store_on is_published is_subscribed is_merge_published is_distributor is_sync_with_backup service_broker_guid is_broker_enabled log_reuse_wait log_reuse_wait_desc is_date_correlation_on is_cdc_enabled is_encrypted is_honor_broker_priority_on replica_id group_database_id resource_pool_id default_language_lcid default_language_name default_fulltext_language_lcid default_fulltext_language_name is_nested_triggers_on is_transform_noise_words_on two_digit_year_cutoff containment containment_desc target_recovery_time_in_seconds delayed_durability delayed_durability_desc is_memory_optimized_elevate_to_snapshot_on is_federation_member is_remote_data_archive_enabled is_mixed_page_allocation_on is_temporal_history_retention_enabled
master 1 0x01 2003-04-08 09:13:36.390 140 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False True False False False False False False False False 00000000-0000-0000-0000-000000000000 False 0 NOTHING False False False False 0 NONE 0 0 DISABLED False False False True False
 hidden batch(es)


SELECT * FROM sys.databases where name not like '%fiddle%' ORDER BY database_id OFFSET 0 ROWS FETCH NEXT (SELECT CAST(CEILING((COUNT(*) * 10.0/100.0)) as int) FROM sys.databases) ROWS ONLY;
name database_id source_database_id owner_sid create_date compatibility_level collation_name user_access user_access_desc is_read_only is_auto_close_on is_auto_shrink_on state state_desc is_in_standby is_cleanly_shutdown is_supplemental_logging_enabled snapshot_isolation_state snapshot_isolation_state_desc is_read_committed_snapshot_on recovery_model recovery_model_desc page_verify_option page_verify_option_desc is_auto_create_stats_on is_auto_create_stats_incremental_on is_auto_update_stats_on is_auto_update_stats_async_on is_ansi_null_default_on is_ansi_nulls_on is_ansi_padding_on is_ansi_warnings_on is_arithabort_on is_concat_null_yields_null_on is_numeric_roundabort_on is_quoted_identifier_on is_recursive_triggers_on is_cursor_close_on_commit_on is_local_cursor_default is_fulltext_enabled is_trustworthy_on is_db_chaining_on is_parameterization_forced is_master_key_encrypted_by_server is_query_store_on is_published is_subscribed is_merge_published is_distributor is_sync_with_backup service_broker_guid is_broker_enabled log_reuse_wait log_reuse_wait_desc is_date_correlation_on is_cdc_enabled is_encrypted is_honor_broker_priority_on replica_id group_database_id resource_pool_id default_language_lcid default_language_name default_fulltext_language_lcid default_fulltext_language_name is_nested_triggers_on is_transform_noise_words_on two_digit_year_cutoff containment containment_desc target_recovery_time_in_seconds delayed_durability delayed_durability_desc is_memory_optimized_elevate_to_snapshot_on is_federation_member is_remote_data_archive_enabled is_mixed_page_allocation_on is_temporal_history_retention_enabled
master 1 0x01 2003-04-08 09:13:36.390 140 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False True False False False False False False False False 00000000-0000-0000-0000-000000000000 False 0 NOTHING False False False False 0 NONE 0 0 DISABLED False False False True False
tempdb 2 0x01 2020-01-15 17:19:23.993 140 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False True False False False False False False False False 01e2db2e-95a9-48be-8925-592698db0a18 True 0 NOTHING False False False False 0 NONE 60 0 DISABLED False False False False False
model 3 0x01 2003-04-08 09:13:36.390 140 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False False False False False False False False False False 00000000-0000-0000-0000-000000000000 False 0 NOTHING False False False False 0 NONE 60 0 DISABLED False False False True False
msdb 4 0x01 2017-08-22 19:39:22.887 140 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True True True False False False False False False False False 8158d87b-77eb-46d9-bebe-c7829adbc4d6 True 0 NOTHING False False False False 0 NONE 60 0 DISABLED False False False True True
 hidden batch(es)