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

My apologies for the mistype on OpenQuery. I spent all day querying stuff with a lot of underscores in the name. I think my fingers just defaulted to that without...