I think a view with an ORDER BY needs TOP in the SELECT.

Also, selecting from a view with an ORDER BY does not guarantee order of the result. An...

If you're running in Azure SQL Database, there are two mechanisms that can allow you to set up a read only secondary that you can then point the AI to....

How are you measuring the duration and getting the average? DMVs, Query Store, Extended Events?

Is it linear?

I agree. It would have to be an added column on a given table that states the source of the data. You could create a user-defined-type using ENUM for the...

Something like this would do it:

WITH datebreakdown
AS (SELECT DATEPART(hh, sod.ModifiedDate) AS hourval,
           DATEPART(mi, sod.ModifiedDate) AS minval,
 ...

I'm pretty sure every union on the planet would lose their minds over what my job entails. The number of weekends that just go away. Holidays I don't get. Crazy...

How do you control production deployments without source control? How can you be sure that the code that was tested is what gets deployed? In our world, nothing gets...

"It's a pull because you're asking someone to accept your code. You pushed it into the Pull Request, but they don't have to take it. They have to pull...

You can. However, it's work to get it set up well so you get the info you want without putting too much load on the system.

Extended Events has a thing...

I see your point, Grant. I hesitate because I saw what happened when we had TFS on-prem. My employer is so dead set against spending any money that when...

Rod, they could set up a central Git server, no cost at all, locally and then use that. It's going to be all command line driven (although I'm sure there's...

Yeah, in all seriousness, I can't imagine not using it. Heck, I use...

Strong suggestion, don't use Profiler. The GUI puts considerable load on a server. Trace Events, the underlying technology, aren't all that kind to a server either. Instead, use Extended Events.

Also,...

You know it does. We've talked about this. Why do you keep bringing it up?

Deadlocks are, at least in part, a performance problem. If all the transactions occur fast enough, the deadly embrace is less likely to occur and deadlocks are avoided. Yes, fundamentally...