April 29, 2013 at 9:08 am
You know how you tell people over and over again that certain preconditions need to be met in order for a certain piece of code to run correctly?
Do that enough times and one would think one is an expert in this.
And then the code takes forever to run in a test environment and won't stop running and so you troubleshoot the crap out of it trying to make sure the indexes are correct, that you have all your columns, that the data isn't doubled or tripled up on...
And after three days of banging your head against the wall you remember "Oh, I wonder what the pre-condition looks like?" and realize "Um, crap. They didn't set it up. No wonder this thing won't stop spinning it's wheels!"
You know how that goes?
Guess what my morning (and last week) have been. #headdesk
Really I don't know why it wasn't the first thing I checked.
April 29, 2013 at 10:25 am
Brandie Tarvin (4/29/2013)
You know how you tell people over and over again that certain preconditions need to be met in order for a certain piece of code to run correctly?Do that enough times and one would think one is an expert in this.
And then the code takes forever to run in a test environment and won't stop running and so you troubleshoot the crap out of it trying to make sure the indexes are correct, that you have all your columns, that the data isn't doubled or tripled up on...
And after three days of banging your head against the wall you remember "Oh, I wonder what the pre-condition looks like?" and realize "Um, crap. They didn't set it up. No wonder this thing won't stop spinning it's wheels!"
You know how that goes?
Guess what my morning (and last week) have been. #headdesk
Really I don't know why it wasn't the first thing I checked.
Because after telling them soooo many times you trusted that they did what you told them was needed.
You need to stop being so trusting 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 29, 2013 at 11:08 am
SQLRNNR (4/29/2013)
Brandie Tarvin (4/29/2013)
You know how you tell people over and over again that certain preconditions need to be met in order for a certain piece of code to run correctly?Do that enough times and one would think one is an expert in this.
And then the code takes forever to run in a test environment and won't stop running and so you troubleshoot the crap out of it trying to make sure the indexes are correct, that you have all your columns, that the data isn't doubled or tripled up on...
And after three days of banging your head against the wall you remember "Oh, I wonder what the pre-condition looks like?" and realize "Um, crap. They didn't set it up. No wonder this thing won't stop spinning it's wheels!"
You know how that goes?
Guess what my morning (and last week) have been. #headdesk
Really I don't know why it wasn't the first thing I checked.
Because after telling them soooo many times you trusted that they did what you told them was needed.
You need to stop being so trusting 😀
Yep. There's a reason that level 1 hardware support always insists on asking you whether the computer is plugged in to a working electrical outlet, even after you tell them you have a computer science degree from Stanford and a raft of certifications. Make sure the customer has done the simple stuff right before spending time on more complicated diagnostics!
Jason Wolfkill
April 29, 2013 at 4:16 pm
Hey guys, asking for a bit of guru inpsection over on this thread I just created:
http://www.sqlservercentral.com/Forums/Topic1447802-392-1.aspx
Basically it's a test harness to try to figure out the most optimal approach to recreate the GREATEST function that you'll find in MySQL/Oracle. Either my google-fu failed or I haven't seen anything out there that's actually done end to end harness testing on the methods for optimization, just references to approaches.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 30, 2013 at 7:02 am
dbursey (4/29/2013)
jcrawf02 (4/29/2013)
L' Eomot Inversé (4/28/2013)
dbursey (4/26/2013)
jcrawf02 (4/25/2013)
L' Eomot Inversé (4/24/2013)
jcrawf02 (4/24/2013)
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
Is the inference that Anne McCaffrey is "the wrong stuff"?
Yes, but only in the sense that if the kids had read her it would make the "evil dragons" story seem a bit odd. That of course would be a good thing, since a dragon is a man's best friend and reading McC would give the kids some defence against corruption by stories of nasty dragons because they would know that all dragons are nice, wouldn't it. :Whistling:
Ha! Gotcha.
Hmmm, where do the hapless dev's fit into this story? I don't want to be a villager!!! Or even one of the aristocracy! I want my own white dragon, that's what I want. 😀
Oh, the devs are the harpers of course. What else could we imaginably be? 😎
Thread...
Oh, no way. We may be annoying in our immediately noticing when something is wrong, but I don't think that makes Thread. I'll go with Harpers. Exploring new places, living to tell the tale...yup, that's how I feel when I'm the first one in in the morning and the refreshes haven't worked...
I don't know...
- invades the environment without warning - check
- modifies surroundings to suit itself - check
- seeks to replicate changes - check
- only really stoppable through the use of fire - check
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 30, 2013 at 12:16 pm
And there's a target on my back. Again.
ffs, it's not as if there's some massive prize out for the 1st person who corrects me each week. :angry:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2013 at 12:33 pm
GilaMonster (4/30/2013)
And there's a target on my back. Again.ffs, it's not as if there's some massive prize out for the 1st person who corrects me each week. :angry:
Are we talking about the order of index rebuilds this time? Seems like it the same person doing it as well.
April 30, 2013 at 12:43 pm
GilaMonster (4/30/2013)
And there's a target on my back. Again.ffs, it's not as if there's some massive prize out for the 1st person who corrects me each week. :angry:
Yes there is, we just haven't told you about it yet...
😉
(I kid! I kid!)
Jason
(hoping I haven't ticked Gail off at me now...)
April 30, 2013 at 1:58 pm
jcrawf02 (4/30/2013)
dbursey (4/29/2013)
jcrawf02 (4/29/2013)
L' Eomot Inversé (4/28/2013)
dbursey (4/26/2013)
jcrawf02 (4/25/2013)
L' Eomot Inversé (4/24/2013)
jcrawf02 (4/24/2013)
Lynn Pettis (4/23/2013)
L' Eomot Inversé (4/23/2013)
Jeff Moden (4/23/2013)
Heh... to complicated. Just take Jason.A to work and let him entertain the kids with stories of GPO's as if they were dragons. 😛That's too risky; if the kids have been reading the wrong stuff they'll be seeing the GPO's as heroic dragons and the DBAs as foul thread.
Safer would be to present the sysadmins as evil sorcerors casting foul black magic spells upon the system's GPO defenses to make them betray their purpose and harm the system instead of defending it.
How many others caught the reference to the Dragon Riders of Pern??
Is the inference that Anne McCaffrey is "the wrong stuff"?
Yes, but only in the sense that if the kids had read her it would make the "evil dragons" story seem a bit odd. That of course would be a good thing, since a dragon is a man's best friend and reading McC would give the kids some defence against corruption by stories of nasty dragons because they would know that all dragons are nice, wouldn't it. :Whistling:
Ha! Gotcha.
Hmmm, where do the hapless dev's fit into this story? I don't want to be a villager!!! Or even one of the aristocracy! I want my own white dragon, that's what I want. 😀
Oh, the devs are the harpers of course. What else could we imaginably be? 😎
Thread...
Oh, no way. We may be annoying in our immediately noticing when something is wrong, but I don't think that makes Thread. I'll go with Harpers. Exploring new places, living to tell the tale...yup, that's how I feel when I'm the first one in in the morning and the refreshes haven't worked...
I don't know...
- invades the environment without warning - check
- modifies surroundings to suit itself - check
- seeks to replicate changes - check
- only really stoppable through the use of fire - check
Your first point is not of course part of thread behaviour - the times and duration of turns turn out to be quite predictable. Thus anything with that first behaviour can't be thread, so neither DBAs nor Developers nor Testing Specialists can be thread. Of course lack of that behaviour doesn't exclude QA types other than Testing Specialists, nor indeed Salesmen, from being thread, since they seem to select random (but rather frequent) times at which to undertake their destructive invasions.
But the next two of your points are two of the four principal behaviours of those who specialise in database administration - ie DBAs. And your fourth point is an attribute of DBAs, as well as of Testing specialists, Developers, and Salesmen (provided one accepts the use of fission or fusion bombs as a form of fire).
The other two principal behaviours of DBAs are:
1: they believe that the function of normalisation is to protect the data and make queries go faster rather than to ensure that the schema conforms to business requirements and permits straightforward development of apps that will benefit the business and not wreck it, so they reckon it is fine to carry out "optimisations" of the schema as long as they don't directly damage the data. We devs call these "optimisations" de-normalisation and know that they often cost an arm and a leg in the development of complex and therefore buggy application code, which in turn costs the business another arm and another leg in reputation repair and in down time, to do something the schema should be doing on its own without any such code, as well as ensuring that ongoing functional evolution of the system of which the database forms part will soon become impossible
2: they think that error management is about ensuring that failures of system components do not cause data loss, rather than about ensuring that failures of system components do not damage the business in any way (which, although it often - but not always - entails avoiding data loss, more importantly also entails far more than just that.)
But of course if I expect to convince a DBA of these things I should change my name to don Quixote de la Mancha, or perhaps to Eejut Gowk.
Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of course that is possibly because I haven't read sufficient Lovecraft.
Tom
April 30, 2013 at 3:05 pm
L' Eomot Inversé (4/30/2013)
Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of course that is possibly because I haven't read sufficient Lovecraft.
Heh... wouldn't it be fun to write a story about the DBAs who first managed the Matrix or SkyNet and how, like many other jobs, were ultimately replaced by machines and the code that drives them? Maybe even have the intelligence and skill of a DBA transferred to a machine (Robocop style).
--Jeff Moden
Change is inevitable... Change for the better is not.
April 30, 2013 at 3:28 pm
Jeff Moden (4/30/2013)
L' Eomot Inversé (4/30/2013)
Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of course that is possibly because I haven't read sufficient Lovecraft.Heh... wouldn't it be fun to write a story about the DBAs who first managed the Matrix or SkyNet and how, like many other jobs, were ultimately replaced by machines and the code that drives them? Maybe even have the intelligence and skill of a DBA transferred to a machine (Robocop style).
ROBODBA
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 30, 2013 at 3:37 pm
Jeff Moden (4/30/2013)
L' Eomot Inversé (4/30/2013)
Anyway, I'm at a loss to think of a good role to assign to DBAs in the worlds of science fiction and fantasy. Of course that is possibly because I haven't read sufficient Lovecraft.Heh... wouldn't it be fun to write a story about the DBAs who first managed the Matrix or SkyNet and how, like many other jobs, were ultimately replaced by machines and the code that drives them? Maybe even have the intelligence and skill of a DBA transferred to a machine (Robocop style).
That would be one seriously cranky computer. It would make a Terminator look merciful and kind.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 1, 2013 at 5:30 am
jcrawf02 (4/30/2013)
dbursey (4/29/2013)
jcrawf02 (4/29/2013)
L' Eomot Inversé (4/28/2013)
dbursey (4/26/2013)
jcrawf02 (4/25/2013)
Hmmm, where do the hapless dev's fit into this story? I don't want to be a villager!!! Or even one of the aristocracy! I want my own white dragon, that's what I want. 😀Oh, the devs are the harpers of course. What else could we imaginably be? 😎
Thread...
Oh, no way. We may be annoying in our immediately noticing when something is wrong, but I don't think that makes Thread. I'll go with Harpers. Exploring new places, living to tell the tale...yup, that's how I feel when I'm the first one in in the morning and the refreshes haven't worked...
I don't know...
- invades the environment without warning - check
- modifies surroundings to suit itself - check
- seeks to replicate changes - check
- only really stoppable through the use of fire - check
HA!
I love it. (And it's so so true.)
May 1, 2013 at 5:33 am
SQLRNNR (4/30/2013)
ROBODBA
Apparently I lack the internet savvy.
HUH?
May 1, 2013 at 6:25 am
Brandie Tarvin (5/1/2013)
SQLRNNR (4/30/2013)
ROBODBAApparently I lack the internet savvy.
HUH?
RoboCop == ROBODBA
😀
"normalize your tables.
Or there will be trouble"
😎
Viewing 15 posts - 39,556 through 39,570 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply