I am not a licensing expert but unless we are talking about Developer Edition in a dev, test, or demo environment, or the free Express version, the only time a...

Since in your first query where you're creating #SlowRunningQueries you already join to sys.dm_exec_sql_text, you can get most of the objects by adding these 2 lines to your SELECT clause:
[code...

Do you track the used space per database?  I've found it helpful to keep info about it in a separate DBA only database so I can analyze what the average...

My take on it, similar to what Grant and Jeff have said, is that the clustered index isn't necessarily the primary key, so the foreign key would reference that instead...

If the person asking is non-technical, I'll explain that "I work with computers, half of my job is trying to get them to do what they are supposed to do,...

I think your unit of measure might be wrong in the EVENT as well.  You're checking duration > 10000, which I believe is 0.01 seconds, and could be a very large...

The more modern sample database to use is World Wide Importers:
https://blogs.msdn.microsoft.com/samlester/2016/06/13/so-long-adventureworks-well-miss-you-and-hello-world-wide-importers/

However if you are really on SQL Server 2012 and want to stay with AdventureWorks,...

OK, I hope your able to figure it out, the e-mail I get does have the listing of job steps that I expected from my job history, so I'm not...

I'm not able to replicate the problem you describe with this code.  I just changed the @profile_name and @recipients parameters and I get an e-mail sent from my server.

No, I haven't seen this, I'd have to see the code you used to better understand the situation.

Unfortunately with the way you have to manipulate the query to make it produce HTML table formatting, you would have to use the original query I gave you and store...

I think the thing that people tend to forget, is that the Normalization process for a database is NOT part of the design process, it is part of the analysis...

I'm not familiar with what reporting..sqljobstatus is.  To adapt my query for use in HTML output, try:
DECLARE @tableHTML NVARCHAR(MAX) ;
DECLARE @s-2 VARCHAR(max)
SET @s-2 =...

You should be able to get all of this information from the table msdb.dbo.sysjobhistory
https://docs.microsoft.com/en-us/sql/relational-databases/system-tables/dbo-sysjobhistory-transact-sql?view=sql-server-2017&viewFallbackFrom=sql-server-2005

A query for this might look something like:
SELECT LEFT(j.name,40)...