Yikes. That's rough. You have my sympathies.

They won't amputate the leg? That's the usual treatment.

Both dogs and cats do quite well with 3 legs. That's why vets started putting the vaccines in the rear legs, to...

True true.

Changing the subject... Last week was fun. One of my cats ended up with a large bump suddenly appearing on her leg. As I've been through this before, I had...

Neil,

You know what I've heard a lot of recently? CISSP certified security people are in high demand right now.

Granted, it's a hard cert to study for and get. You have...

Nevermind. I needed to leave out the SQL keyword.

Ha yeah I was reluctant to test it out.  Sorry for the syntax issues.  Originally I had a table CREATE statement but then switched to SELECT INTO because that's...

• This reply was modified 3 months ago by Brandie Tarvin.

This isn't code, but you could also put a max size on tempdb so you don't need to have as much use to run out of space if you...

21 years is a good run. It's a shame about the redundancy right before the holiday season. I don't know if my company has openings for your skill set or...

Bah, humbug. It's erroring out.

FYI: Your "into #t" is in the wrong spot.

And I need to figure out the below error. I think my sandbox server is a version lower...

• This reply was modified 3 months, 1 weeks ago by Brandie Tarvin.

Heh. No worries. I'm doing this on a sandbox server. I'll give it a try. Thanks.

Sooooooo quiet around here....

Could use some help here if you've of a mind: Need to overload tempdb – SQLServerCentral Forums.

Thanks. Hope everyone is doing well.

That is an interesting read. And I'm glad it didn't gloss over the moderator nonsense.

Catching up to this article several years after it was written... Seems like they intended to do that with Windows 10 but now EOL is this October and whether or...

It's the middle of the night and I'm online for "reasons."

Looking at your link, Jeff, somebody didn't proofread their code or didn't care. Samples 1 & 4 are identical code....