Just realized this is a six year old post. I still stand by what I said though.

Extended Events!

I know, I know. It's sometimes all I talk about.

The issue is simple. Extended Events, the core underlying architecture, is pretty amazing and clearly used by all the different...

Here's an example. Probably best to trim some of the events away, and obviously you'll want a different set of filter criteria.

Extended Events, with causality tracking, can show you exactly when & how statistics get updated.

You've got the basics mostly right. Async updates will occur after, not query execution, but after the compile process is complete. This is why, you may still see almost instantaneous...

As Jeff says, I've learned not to argue with him, you can do it all in SQL Server. I've had bad experiences though.

So, yeah, you could do any combination of...

Connection settings, others. It's something.

I'd need to see the execution plans to understand what's going on. Further, two different databases means, possibly, two different sets of data, two different sets of statistics, two different...

Also, one thing to REALLY think about is backup and recovery. Storing files in the database means restoring those files with the database. That becomes a huge headache and can...

Sure sounds like someone tried to enable Azure Arc or something similar. You sure you don't have anything going there?

Strong, strong suggestion.

Don't.

Can you store files within SQL Server? Yes.

Is SQL Server good at storing and retrieving files? No.

However, if you're going to insist on doing it, then I'd focus...

Yes, great article and great comments, and a neat quote from Jeff. When recognition and praise is given where it is due, everyone benefits.

And getting upset when others do well...

You can always see the estimated memory allocation in the execution plan. An actual memory allocation is possible if you capture runtime metrics with the execution plan, also called an...

That's about 5% of the table, so it's unlikely that an index will help tons. However, have you looked at the execution plan for the DELETE statement? How is it...

I sure don't mean for it to be false praise, or even praise for nothing. I've just seen a few people get... for want of a term, upset when they...