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 1 weeks, 1 days 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 1 weeks, 6 days 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....

I feel so embarrassed. It was a typo. Tiny tiny typo. My eyes went past it so many times.

Thanks for your response.

Yes, let's take away the tempdb drives. That's one way to (NOT) keep an instance running.

@=) @=)

And as of a few minutes ago, it's my turn up at bat for the long week of extra work, so I'm going to do an insane thing at the...

As an FYI, columns can be renamed. I work in a place with propriatary information and do it all the time. I make my data samples equal references to Disney...

But, but, but... I DO have a problem.

My application isn't working. You know the one I'm talking about. Where I input information about the customer and it does ... schtuff.

It...

<lurch><lurch><shuffle>

"CPUUUUUUUU.... CPUUUUUUUUUU...."

"Memoreeeeeeeeeeee..."

<lurch><lurch><shuffle>

"Dataaaaaaaaa...."