I'm not affiliated with dbt in any way and I'm not spamming. dbt is a popular tool used for creating views and other artifacts as a part of ELT workflows,...

Did this get written up?

If one has already been submitted, I won't write this up.

I'll write this up.

Submitted

I'll take this one.

This has been submitted.

I'll submit an article for this in the next couple days.

Nevermind, just saw the one about JSON today. I'll pick something else.

I thought this was an exact copy of my question from 8/2! Didn't catch table2 was not temp. Need coffee....

I'll throw one together about JSON.

Good read:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/12/bad-habits-to-kick-using-the-wrong-data-type.aspx

If they are in fact stored procedures, there are built in system functions that will return all tables included in the stored procedure. You can take your list of...

Are the jobs in the SQL Server agent executing stored procedures? Or are they executing raw embedded sql?

Have you read through this yet?

https://blogs.msdn.microsoft.com/psssql/2010/10/28/query-performance-and-multi-statement-table-valued-functions/