SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBA vs Developer


DBA vs Developer

Author
Message
Sean Pearce
Sean Pearce
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1760 Visits: 3432
I just wanted to share this. (Disclaimer: This conversation was between a junior developer and a senior DBA).

Developer: You haven't configured tempdb correctly. I keep getting an error that it is running out of space.
DBA: It must be your code, tempdb is configured correctly. Let me see the error message.
Developer: It can't be my code. Here is the error.
DBA: It is definitely your code. You are spilling like crazy. Let me see the estimated execution plan.
Developer: The what?
DBA: Let me show you.





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Attachments
Holy Sort Batman.png (437 views, 11.00 KB)
Eirikur Eiriksson
Eirikur Eiriksson
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14888 Visits: 18591
Hmm, 4,85 x 10^14, that would be one row for each mile of blood vessel in every human on earthw00t
Cool
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39237 Visits: 32616
You mean you didn't flip the infinity switch on your tempdb? That developer is right, you have it configured incorrectly.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
jarupan
jarupan
SSC-Enthusiastic
SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)

Group: General Forum Members
Points: 118 Visits: 388
Hi Grant,
This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I switch it?


Thank you in advance.

JJ
Luis Cazares
Luis Cazares
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16272 Visits: 19059
jarupan (7/18/2014)
Hi Grant,
This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I switch it?


Thank you in advance.

JJ


You need to request it to Microsoft. It's an option exclusive to MVPs that have written more than one book.

Seriously, that was a joke from him. Hehe


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
AppSup_dba
AppSup_dba
Old Hand
Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)

Group: General Forum Members
Points: 318 Visits: 716
Grant people take you seriously... Be considerate... :-D

Cheers
Grant Fritchey
Grant Fritchey
SSC-Dedicated
SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)SSC-Dedicated (39K reputation)

Group: General Forum Members
Points: 39237 Visits: 32616
jarupan (7/18/2014)
Hi Grant,
This is the first time I see about infinity switch. Does it mean unlimited growth in TempDB? If not, would you pleasee explain and how can I switch it?


Thank you in advance.

JJ


Apologies.

That was humor. The OP was illustrating a semi-funny situation with the large estimate and his developers response to the problem. I responded in kind. Sorry for the confusion.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
HanShi
HanShi
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4363 Visits: 3668
For the fun of it you wish you could increase the TEMPDB to 93000TB and then watch how the developer handles the resultset in the application. He probably will loop through each row to get to the single one row he needs....



Edit: forgot to type the 0's with the required size. I'm not used to deal with such high volumes...

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Ed Wagner
Ed Wagner
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16455 Visits: 10050
That is funny. Think about it - 92045 TB? Since I don't work for the government, so I can't fathom spending that kind of money on hardware. Then again, it might help if they used a petabyte SAN built with SSDs. What's next? Naturally, make it a memory-optimized table. :-D

PS: This is also intended as humor.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
jarupan
jarupan
SSC-Enthusiastic
SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)

Group: General Forum Members
Points: 118 Visits: 388
Thank Grant for verify it, do not take it seriously. I can not assume that I know everything.
For example in 2003, I worked as consultant in Title company in Ohio. One DBA wanted me to help him for his usp_ that took ~ 5 minutes to run, I made it to ~ 1 minute to run but it called one system stored procedure, manager happy about that. But VP did not like that , he called Microsoft and change that system stored procedure, after change the job took only 15 seconds to run and that opened my eye. Up until now, I still do not know how he changed it but it was changed . From that time, I open myself to any info.
Some kind of naive but I learn something new everyday.


Thank again

JJ
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search