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

Focus on the fact that what you're looking at are databases. Ignore the concept of a server. Yeah, it's still there, but it's radically easier to make the shift if...

Starting with the execution plan, you have a lot of issues. This is in no way a simple query. And views that join other views calling other views and functions,...

Partitioning is a data management process, not a performance enhancement process. In fact, unless you can with 100% accuracy, guarantee that ALL queries against a partitioned table will be using...

I am not sure profiler would be of much use to you even if it did support it, Synapse doesn't work the same way as a traditional SQL server...

I'd need to see the execution plan to see how the queries are being resolved in order to make suggestions for improvement.

Always? Every time? Hell no.

Frequently? Yeah, probably. If you're doing new or different functionality, then it's probably a good idea to have different structures to appropriately support that functionality. That's...

I know you said the environments are essentially the same, but then you list a number of differences. It's likely that the reason you're seeing it one environment and not...

What about simplifying this a bit and just use the TOP command. All you need is the ORDER BY. You don't have to go into all that row number...