Of course, after I posted this, I realized that the user running the proc can't grant impersonate on themselves, so I'm ripping that part of the code out. But I...

From the "Boy, I feel stupid" department, can someone look at and answer this AG question? Availability Group didn't get secondary DB added? – SQLServerCentral Forums

BTW, does anyone know if hardware (ISCSI controllers, CPU, memory) resolves the issues with 2022?

I know. Hardware shouldn't be required to fix bad code... but sometimes poor performance can be...

Thanks for the post about SQL 2022, Jeff. I've reached out to my team and mentioned that we need to fix all the problems we're currently having with SQL 2017...

It's interesting. A few months ago, I had that very same ACE 32 bit vs 64 bit argument with a few people at my new shop. And someone insisted they...

The one I'm looking at has 3 legs and a pink bowtie around its neck. So I must be a little behind you, Phil.

Sigh. Nope. We should be managing dirty reads on the statement level - not the session level - because apparently there may be some statements in a stored procedure that...

Ok... let's...

Hey, binary still has legs on it!

@=)

So I haven't been able to consistently post for a while because stupid issues with website or browser (not sure which, but I didn't actively change anything). And now for...

Jeff, Tally tables aren't working and this RBAR thing is RIDICULOUS. No...

I am not using that silly new name for The Platform Formerly Known as Twitter.

YAY! Website...

I'm not sure. I wasn't the person who did the original server move / install. I will go back and check, though. Thank you for this information.

A brief glance at...

Well, my workplace desktop support is useless on the SSC website issue. I am the only person in the office having problems with it but apparently the issue is SSC....

I have not. But don't they have to be set up in advance?

I found something about SQL Profiler / server trace and perfmon as well, but again, stuff that needs...