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

Honestly, two reasons:

1. We don't have the privileges in...

Two reason, both valid:

1. We don't have the level of access to do this (yeah, it's a weird hosting arrangement)

2. Larger disk = more $$$ = requires approval through our...

Well it's my own dang fault this happened...

The guy on our team responsible for managing our AVDs in Azure we (and the developers) connect to our servers from got an...

Would creating a small, empty database that you TDE-encrypt / decrypt, perhaps on a schedule be an option?  This would satisfy one of the reasons given in the MS Q&A...

--Double post--

• This reply was modified 6 months ago by jasona.work. Reason: double posted due to gateway timeout