Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9553,9563,9573,9583,959»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, April 30, 2013 12:16 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:16 AM
Points: 40,194, Visits: 36,599
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.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1448187
Posted Tuesday, April 30, 2013 12:33 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 20,734, Visits: 32,506
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.


Are we talking about the order of index rebuilds this time? Seems like it the same person doing it as well.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1448198
Posted Tuesday, April 30, 2013 12:43 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 10:22 AM
Points: 730, Visits: 5,329
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.


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...)
Post #1448200
Posted Tuesday, April 30, 2013 1:58 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 7,801, Visits: 9,551
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.
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
Post #1448227
Posted Tuesday, April 30, 2013 3:05 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 35,366, Visits: 31,905
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
"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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1448252
Posted Tuesday, April 30, 2013 3:28 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 17,822, Visits: 15,747
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
Post #1448259
Posted Tuesday, April 30, 2013 3:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1448260
Posted Wednesday, May 1, 2013 5:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:28 AM
Points: 5,584, Visits: 6,380
jcrawf02 (4/30/2013)
dbursey (4/29/2013)
jcrawf02 (4/29/2013)
L' Eomot Inversé (4/28/2013)
dbursey (4/26/2013)
[quote]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.)


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1448373
Posted Wednesday, May 1, 2013 5:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:28 AM
Points: 5,584, Visits: 6,380
SQLRNNR (4/30/2013)

ROBODBA


Apparently I lack the internet savvy.

HUH?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1448374
Posted Wednesday, May 1, 2013 6:25 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 10:22 AM
Points: 730, Visits: 5,329
Brandie Tarvin (5/1/2013)
SQLRNNR (4/30/2013)

ROBODBA


Apparently I lack the internet savvy.

HUH?


RoboCop == ROBODBA


"normalize your tables.
Or there will be trouble"
Post #1448386
« Prev Topic | Next Topic »

Add to briefcase «««3,9553,9563,9573,9583,959»»»

Permissions Expand / Collapse