📅 October 2021
(3 posts)
📅 2021-10-28
✍️ Bart Schelstraete
The T-SQL code below lists the currently running SQL Agent jobs. SELECT ja.job_id, j.name AS job_name, ja.start_execution_date, ISNULL(last_executed_step_id,0)+1 AS current_executed_step_id,…
Read more →
📅 2021-10-10
✍️ Bart Schelstraete
In case you have a screen with a high resolution, a 4K screen for example, it is possible that GRUB is incredibly slow. If that is the case, the workaround is to edit the /etc/default/grub file, and…
Read more →
📅 2021-10-05
✍️ Bart Schelstraete
You can monitor TEMPDB usage by using the following SQL statement. SELECT COALESCE(T1.session_id, T2.session_id) [session_id] , T1.request_id , COALESCE(T1.database_id, T2.database_id) [database_id],…
Read more →