SQL

Count Year,Month,Day

Count Year,Month,Day DECLARE @@FROM VARCHAR(10), @@TO VARCHAR(10), @@DIFF VARCHAR(MAX), @@FLG VARCHAR(1), @@ASSET_NO VARCHAR(MAX), @@MSG VARCHAR(MAX); SET @@MSG = ''; SET ... Read More

SQL Server CPU Kullanım raporu sorgusu

SELECT TOP 200 q.text ,DB_NAME(DatabaseID) AS [DatabaseName] ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (total_worker_time)) / 1000000) AS [CPU_Time_sn] ,qs.execution_count ,CONVERT(NUMERIC(10, 2), (CONVERT(NUMERIC, (total_worker_time)) ... Read More