Rod, thanks for sharing that one. Great insight.

Chris. BWA-HA-HA. Sorry, probably shouldn't laugh.

Nice one Aaron. I've seen people try to make line count a measure. I told 'em straight up, I can make the line count go really, really high if necessary.

HA!...

Maybe I'm being pedantic, but I've never heard of a primary key index. As far as I know, you can make a table with a primary key that is...

I've seen all sorts of different setups. To my mind, there's not a single correct approach. It's down to understanding the architecture and where your bottlenecks are. Especially with a...

I know you fixed this already. Well done. However, figured I'd post this in case you, or anyone else, needs to hear it.

Databases are code.

They are. Yes, yes, the data...

Grant, I totally agree.  It has served me well in my career to always own up to mistakes.  Another developer I worked with always said it happens that sometimes...

Thanks for all the feedback everyone. For some reason it didn't show up in my email as per usual (I probably broke something).

You're not paranoid if they really are out to get you.

And they are.

Oh, ouch.

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