SQL Server’da Veritabanı Hakkında Bilgi Öğrenmek

Herkese merhaba,

Bu kısımda SQL Server’da veritabanı hakkında bilgi öğrenme kodları olacak.

select upper(name) as [DBNAME],
recovery_model_desc as [RecoveryModel],
PageDetection=(case Page_verify_option_desc
when 'CHECKSUM' then 'CHECKSUM'
else page_verify_option_desc +': Warning: Microsoft recommends to use Checksum' end),
AutoShrink=(case is_auto_shrink_on
when 0 then 'OFF' 
else 'ON: Warning---AutoShrink cause severe performance issue, if not application requirement, please turn it OFF' end),
DBOWNER=(Case owner_sid
when suser_sid('sa') then 'SA'
else suser_sname(owner_sid)+': It is recommended to change the dbowner to SA' end),
'SQL'+substring(@@version,22,4) as SQLVersion,
CompatibilityLevel=(case when compatibility_level = 110 then 'SQL2012'
when compatibility_level=100 then 'SQL2008'
when compatibility_level=90 then 'SQL2005'
when compatibility_level=80 then 'SQL2000' end),
AutoUpdateStats=(case is_auto_update_stats_on
when 0 then 'OFF'
else 'ON: Its recommended to turn it off and schedule a weekly\daily job' end),
Log_reuse_wait_desc as [WhyLogCanNotBeReUsed]
from sys.databases
go