One of the first things you should do is to download Brent Ozar's first responder kit and run it.

Here's where you can get the kit...

https://www.brentozar.com/first-aid/

Here's where you can learn to...

Heh... it's funny how timely this article is, Grant.

One of the companies that I do a little work for has customers that must be responsible for the following meme...

I'm a retired IT guy in his 80s fighting boredom by trying to learn new things.  SQL is the newest topic.

Am I in the right place or do you...

How to rewrite a query in MS SQL:

WHERE a.ROWID IN (SELECT rid

FROM ( SELECT ROWID rid,

row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn

FROM details c

WHERE a.id = c.id

AND...

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...