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
SSCrazy Eights
SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)SSCrazy Eights (9.1K reputation)

Group: General Forum Members
Points: 9110 Visits: 3436
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 (449 views, 11.00 KB)
Eirikur Eiriksson
Eirikur Eiriksson
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93653 Visits: 20656
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 Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221357 Visits: 33556
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
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1012 Visits: 398
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
SSC Guru
SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)SSC Guru (95K reputation)

Group: General Forum Members
Points: 95318 Visits: 21200
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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

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

Cheers
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221357 Visits: 33556
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
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18491 Visits: 3787
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
SSC Guru
SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)SSC Guru (156K reputation)

Group: General Forum Members
Points: 156571 Visits: 11650
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
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1012 Visits: 398
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