I'm learning xml. I'm getting the hang of the nitty gritty, tags, elements, etc. I haven't come across the WHY except that it's "good for sharing across platforms."...

Well what do you get when you comment out the Row_Num2 check in the where clause and include it in the output?

Also keep in mind in your CTE the count...

It looks like you would want this count(d.dx_class_id) over (partition by d.dx_class_id order by d.dx_class_id) Row_Num2

Partitioned by pat_id not dx_class_id

In all fairness if the commands are  coming from SSMS it's...

In all fairness if the commands are  coming from SSMS it's not problems...

I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff...

Try taking a look at theses 2 management views.  Change the ORDER BY in your queries to get highest use per I/O, CPU, Memry

Mostly it's just about proper branding when you're applying for a job if you have 12+ years experience working with data bases.  For example do you ever write queries?  Congratulations...

Memory used is not a particularly useful metric in SQL Server.  It grabs as memory and never releases it so that it can keep as much as possible in memory.

Well what unit of time do you want to see?

SSIS is a good tool for that, but save yourself some trouble and export it as a csv unless someone complains.

How are you calculating the monthly totals now?

It's also missing a handful of features like SQL agent, so no scheduling stuff directly in SQL Server and no database mail so no easy reporting and notifications from SQL...

Well what value does this return?

(SELECT MAX(BusinessEntityId) AS BusinessEntityId FROM Person.Person)

The code provided is creating an array with all the key/value pairs in the file in it.  You can either filter at the point of the array creation or only...