Two more thoughts, then, and a comment:

1. Check the Event Logs on the server that has the Access files on it, especially the Security Event Log.  Look for any failures,...

You also need to grant the SQL Server service account permission to the network share and the file.  If you're using a Domain service account, it'll be easy, it's just...

Steve, Grant, thanks.  At least if (when, I hope) the conference gets approved, I don't have to worry as much about daily budgeting, we've got a fairly (well, last year,...

Some days I am not a fan of my employer...

Put in the paperwork to get a trip to Summit covered for this year, but because the head honcho is leaving...

So I will note, storage could still be a problem, we're in Azure and a few of our apps had unacceptable database performance until we bumped up the storage tier...

My tendency on here (I'm not on a lot of forums to speak of) when I see what "feels like" a homework question or a "URGENT, need answer quick" question...

So presuming it's a spike in PAGEIOLATCH_SH when the query runs with the varbinary, that's an indicator that the problem *could* be the storage on the server.

Can you give some...

My suspicion is that it's not so much that the query is taking longer to execute, as it is taking more time to send the results to (I'm presuming) SSMS...

The timing on this editorial couldn't be better.  While I'm happy where I'm at, occasionally I get the "itch" to see what the grass is like on the other side...

One thing I'm seeing come up in several of the responses has been the office being relocated at the same time (or close enough) to the RTO mandates.

If nothing else,...

My employer has gone to a full RTO with no exceptions.  We'd originally started thinking we'd be doing 50% WFH / 50% in-office, but then the orders came down.  So...

If you're going about your daily routine at work and think to yourself: "I could automate most every task I'm doing.", then there is a strong possibility that your...

Put me in the "techie-focussed" events column as well.  I've been to a couple SQL Saturdays (and have the same issue as Rod, there's none close), a few SQL User...

Honestly the biggest gripe with Azure VMs (where we are now) is the lack of flexibility in drive sizing.  It's all multiples of 64, so 64 / 128 / 256...

I have the same things to deal with.  Getting more space requires divine intervention.  We started combatting this by creating a database named "MT" on the servers.  We size...