The "JOIN" in the second query is in the WHERE clause as...

and (DFR.transaction_header_guid = ICT.transaction_header_guid)

It's also referred to as an "old style" or "Non-SANSI" "Equi-Join"

Jeff Moden called it a Consensus Engine, which I thought was a brilliant description.

It's pretty much at peak hype in the hype cycle.  It is genuinely useful, just not...

For Perplexity.ai, it came so VERY close and, yet, it still failed.  It did write corrected to go after this bit of narrative, though.

It's important to note that the...

+1000!  I've said that it has the "being human" part pretty much down pat.  I very confidently provides the wrong answer...

Yes... that can be done and the methods have been available for quite a while.  The problem is that it's arduous for the server to record information every time a...

Hi Johan,

This issue has been resolved by enabling TraceFlag 3057 on secondary logshipping server and reconfiguring the logshipping for each databases,  now I can see all databases are in...

Good article.  Thanks for taking the time to write it.

I wonder when people will really reconsider what they've done.  I was both shocked and tickled when I saw the articles...

the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.

while there are 2...

This does not show database sizes but rather individual database file sizes. To do what I think you want it to do - show total space used per database, change...

You will need to do the rename the column inside of every coded object, as well.  The textual content is located in sys.sql_modules by object ID.  Obviously, you're going to...

That's one of the ways we made a Partitioned View a whole lot faster.  Instead of...

See the 'tube in the following article...

https://www.scientificamerican.com/article/robots-made-from-human-cells-can-move-on-their-own-and-heal-wounds/

Then, imagine this doing like what Covid did and getting "out of the lab".  We're talking about something that can, in their words, "create...

I am curious as to why you need to call out to PS directly from SQL Server.  If I need to call a PS script from SQL Server -...

ugh... so one thing, i realized... is always check the naming... of the file... really sorry, everything you mentioned is great troubleshooting... when i found the file.. it was...

Is that E: Drive on the server where you're running this or on your...