Tempdb is full due to crappy procedure!!!

Question

Tempdb is full due to crappy procedure!!!

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 1

AndrewMurphy (11/14/2008)
Jeff....
"Um... for what? Using a paltry 40 MB of TempDB?"
...if you read the original message...he was getting TEMPDB full....the only reason TEMPDB was being returned to 40MB was that was the initial size of the file....objective achieved totally by accident:D
I don't think he (or she) is the quality candidate for the next open position in your company....

I read it as it started at 40MB and it grew to 80MB. My bad...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 2

Loner (11/14/2008)
Jeff
Don't even get me started with outsourcing. In my last company, I spent 4 days to finish a very complicated report. The outsourcing company had two developers working on the similar report and they spent 4 months working on it and could not even finish the query. They kindly asked if they could 'borrow' my code. I gave to them and still two months later, it was not done.
The application I was talking in this thread was developed by a company in India. Every time there is an issue, we submit a ticket and goes to never, never land. Is the company/people/culture so different in other part of the world ?;)

Nah... no difference in culture... most folks suffer from 1 of the following... either they just don't give a damn or they have bosses that say "Get it done now!" without any understanding that it takes a bit of time to make a quality product or... and this is the usual case... they really don't know SQL. A lot of folks just aren't qualified to use SQL Server for anything other than a place to store data but they don't know what they don't know. 🙂

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)