I searched through this, but it remains unclear to me, is there an index on ContainerTypeName? Preferably where that column is the leading column in the index so it's running...

Have you looked at the execution plan for the query in question? That's going to tell you a whole lot about how it's being executed, what resources are being used,...

Not sure I'd describe Tommy Flowers as a postal worker other than because of the name of the organisation he worked for.

True he worked for the General Post Office...

Instead of installing SQL Server locally for development, you might consider running it as a container. The advantages are, you can turn it on & off without mucking with services....

If there are no transactions, it will only show the older data. There isn't an automatic rest of pg_stats_statements. However, there is a command you can issue to reset it...

You've updated windows, have you updated SSMS and the underlying tools? If not, start there.

If you want more detailed answers, post the full set of code, and probably some of the structure as well.

HI FOLKS

ill go back and check the index's being used on both to ensure both the same (its the exact same query using exact same front end application) only...

Just to emphasize one point, the bacpac is not like a backup. It's not transactionally aware. So, if you can't quiet the database, meaning stop transactions against it, that you're...

To be sure, I'd need to see the query and an execution plan. Also, the collation you're using could affect this. However, in general, no, that shouldn't be a concern....

To be sure, I'd need to see the query and an execution plan. Also, the collation you're using could affect this. However, in general, no, that shouldn't be a concern....

Grant, loved the post.  I remember coming out of college and interviewing for my first job.  I was interview by a 50-something year old who was still a software...

Not dismissing any of what you wrote, all sounds great honestly, but this bit, oh yes!!

I like the way you put it, Grant; "Play to your strengths". I will sometimes daydream about being a CEO because of the money they make, but I think...

A nice read for a Saturday morning. I remember back when I started in my current department and I thought "one day, I want to be a manager like...