I think there's a much easier way, as provided by Microsoft here:

https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/dbo-sysjobactivity-transact-sql?redirectedfrom=MSDN&view=sql-server-2017#example

SELECT sj.Name, 
CASE
WHEN sja.start_execution_date IS NULL THEN 'Not running'
WHEN sja.start_execution_date IS NOT NULL AND sja.stop_execution_date...

I just experienced the same issue with SQL Express 2012, and was able to fix with the same vbs script (direct link) except making the adjustment as mentioned by 'braveson'...

romefor4, thank you for your comments! Much appreciated, and I'm glad you liked the article.

Azure can be used for such a broad range of possibilities that I don't think my...

You can find the MVA course for the 70-462 exam here:

https://www.microsoftvirtualacademy.com/en-US/training-courses/administering-microsoft-sql-server-2012-jump-start-8259

The free trial gives you up to $200 or 30 days worth of activity, whichever comes first. If you remove the billing limit on the account before then, it will...

The system pads the temp table name with underscores and adds a 12 digit uniquifier so that different sessions can use the same temp table name without conflict:

SELECT LEN(name), *...

Dave62 (7/16/2014)

---

nimbell (7/15/2014)

---

Question didn't really make an adequate distinction between the logical and the physical:

Does the logical definition of a Primary Key imply the presence of an index? No

In SQL...

Question didn't really make an adequate distinction between the logical and the physical:

Does the logical definition of a Primary Key imply the presence of an index? No

In SQL Server, does...

I got it wrong, but learned something new, so good question. Phrasing it as: "The query only returns one record. This is because..." might have been more on point, though.

I think the issue of skill growth (call it training, professional development, or just 'experience') is fundamental. Too often (in my humble experience), managers have some performance metric that is...

Dave Schutz (6/14/2013)

---

To me it depends on the skills that people are being rewarded for. If we are rewarding people for doing a good technical job, then I'm in favor...

An alternative solution, that uses a recursive CTE instead of a WHILE loop:

--DECLARE @pmd_patient_id bigint = 100128137 --for single patient filtering

;WITH

lteWithChronSeq AS ( --add a per...