Don't get me started in WITH (NOLOCK). Apparently there are a number of people suddenly making that recommendation to get rid of blocking.

It's apparently easier advice to give people than...

Phil: Someone told you that these temp table drops are expensive (in database terms), but without providing evidence, and now they're expecting you just to believe them?

The burden of proof...

Thanks for the links. I will review.

I believe that SQL renames temp tables rather than dropping them, esp. for stored procs.  That way, when the proc runs again, it doesn't have to fully recreate the...

So, I could use some help on this one: To Drop or Not to Drop (the temp table question) – SQLServerCentral Forums

I've tried Googling it but not finding exactly...

I have been having the worst time with this website on my work PC for the past 9 months. Couldn't log in (and login screen looked weird). When I did...

Forgetting the domain was exactly the problem. Now we have an encryption message (the client isn't requesting encryption on encrypted database), but that's an entirely different issue.

Thanks for the help!

Yes and no. The user sent me screenshots of a different login that worked and getting information from him last week was like trying to chase a cat through an...

Dare I ask what happened Saturday that has everyone in a tizzy? As I was paying attention to family and not work or the news.

Also, got a SQL 2017 error...

Is anyone using Idera's SQL Compliance Manager, or something similar?  Auditing requests from our clients is becoming a hot topic.  Some of these are kind of ridiculous, but hey,...

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it accepted...

So I'm updating my internal-to-the-business resume and I'm trying to figure out the best way to spell out "one-stop shop" without actually using those words. How else, in formal /...

Out of interest, has anyone heard or seen from Gail in awhile? I haven't seen them about in ages. I noticed that their website has been down a little...

So it turns out that I needed to reboot the servers because nothing was recognizing that GPG had been installed. GPG didn't say anything about needing a reboot, but once...

Anyone have powershell / SSIS with GPG experience? I could use some help here: https://www.sqlservercentral.com/forums/topic/powershell-calling-gpg-fails-on-sql-job