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

Good morning Grant.  First, I congratulate you on having put in 35 years in IT.  You are a survivor for sure.  I understand your feelings about those who 'climbed...

Love it!

Moving this kind of data truly comes down to hardware (or service tiers if you're in the cloud). All the suggestions will help, but mostly at the margins. More memory,...