Welcome to SQL Server Central.

It looks like the usual has occurred and you have  a couple of good answers to your question. Never hesitate to ask follow-up questions. We like...

Your query is working. I tested it running this:

SELECT *
FROM Sales.SalesOrderDetail AS sod
WHERE sod.SalesOrderDetailID = 432;

And modifying the index to [IX_SalesOrderDetail_ProductID]. It worked fine.

So, the problem must...

Here's the bad news. You need both. If logically the UserName value is the business defined identifying value, you should have a unique constraint on it. This is what is...

The information is captured in system tables. You just have to query those and you're off and running. Take a look at sys.jobhistory. Then, to only get the longest one,...

@Grant: Can you provide me an example on how to do that using Query store or extended events or any article that you can point out that would help...

I'm doing a precon at Columbus.

SPEND YOUR MONEY!!!!!

Here are a bunch of examples from my blog of using Extended Events to answer various questions. This should provide you with a bunch of what you're asking. I'll...

Ah, interesting use of the tools. Unfortunately, I don't know of a way to do it. I'm not saying it can't be done, just that there's not a way I'm...

Really curious what the use case and need is though.

One is for SQL Server version 2016 and the other...

I don't think you can because the hash is created internally based on a structure in the optimizer, not the T-SQL text, that would also have to be recreated. You...

There are built in metrics in Permon that you can use. Here's an article. Chapter 3 (or maybe 4, I forget) of my book also discusses monitoring the network....

You're on 2016. Use the Query Store. Nice and easy way to gather that information. Otherwise, some of the suggestions are good, query the cache, use extended events and...

I'm not aware of a way to do this, no. You can have a query window showing logins. You can refresh that regularly. Or, maybe you're thinking of the Activity...

Good luck. I don't blame you. A friend worked for one when I was growing up. They always got to go to cool places. I just searched for "sql server"...