CREATE TABLE #tmpQueryStore (DBName VARCHAR(128),current_storage_size_mb BIGINT,max_storage_size_mb BIGINT,readonly_reason BIGINT); 8 – database is secondary replica (applies to Always On and Azure ...
declare @sql_used nvarchar(max) = N'USE [?]; INSERT #DbUsed (DatabaseId, Used, Name) SELECT DB_ID(), CONVERT(BIGINT, FILEPROPERTY(name, ''SpaceUsed'')) * 8 / 1024 ...