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

I'm going off what they typed. If that's true, there's the problem and solution. If not, we need to know that.

We can ignore everything else for the moment.

If a query is returning everything from a table, and there is no way to...

As far as I understand it, SQL compiles the plan before it executes.

When you use a variable, SQL compiles a plan for an unknown value.

When you use a fixed...

Ha! Thanks. I'll see if we can do it. We only had yesterday and today to play a little.

For something like this, assuming no other objects involved, it's not a view, you're not running some kind of monitoring, then, my suggestion is as follows. You have very little...