Show last executed queries on sqlserver

queries.md

Show last executed queries on sqlserver

SELECT deqs.last_execution_time AS [Time]
	,dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE lower(dest.TEXT) LIKE '%binaries%'
ORDER BY deqs.last_execution_time DESC

Group data by day

SELECT dateadd(DAY,0, datediff(day,0, [DeletedOn])), count(*)
  FROM [ar_handel].[dbo].[ArchiveLog]
  group by dateadd(DAY,0, datediff(day,0, [DeletedOn]))
  --order by ArchivedOn desc

SELECT dateadd(DAY,0, datediff(day,0, [TimeAdded])), count(*)
  FROM [ws_handel].[dbo].[JobQueue]
  group by dateadd(DAY,0, datediff(day,0, [TimeAdded])) order by dateadd(DAY,0, datediff(day,0, [TimeAdded])) desc

Clean JobQueue

USE [ws_handel]

--DELETE
SELECT count(*)
FROM [JobQueueResults]
WHERE JobId IN (
		SELECT [JobID]
		FROM [JobQueue]
		WHERE [TimeAdded] BETWEEN GETDATE() - 2000
				AND GETDATE() - 540
		);

--DELETE
SELECT count(*)
FROM [JobQueueCommands]
WHERE JobId IN (
		SELECT [JobID]
		FROM [JobQueue]
		WHERE [TimeAdded] BETWEEN GETDATE() - 2000
				AND GETDATE() - 540
		);

--DELETE
SELECT count(*)
FROM [JobQueue]
WHERE [TimeAdded] BETWEEN GETDATE() - 2000
		AND GETDATE() - 540;