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

Well, I just encountered victory of a sorts. After I pushed back and told the Dev this didn't make sense that the two issues were connected, he managed to find...

Ha. I think you're right. NLTM is the method.

I want to point out this part of the code:

   SET @TSql = N'INSERT INTO dbo.PR_Archive  
   SELECT * FROM OPENQUERY([LinedServer],''SELECT Col1,...