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 «««123

Interview question :critical issue faced by dba Expand / Collapse
Author
Message
Posted Tuesday, July 8, 2014 7:02 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
Oh, I don't mind open ended questions for the very reasons you mean. I just hate THOSE types of open ended "explain to me how you've failed" questions. Heh... my answer is "It's my job to not fail. The biggest crisis I've had as a DBA is a logfile finally consuming all of the harddisk on a system they hadn't given me access to yet on the second day of a new job and the second biggest was when I determined that we were going to run out of harddisk space 6 months ahead of time. The first day was spent filling out paper work and peeing in a cup."

--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 #1590344
Posted Tuesday, July 8, 2014 7:40 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 18,064, Visits: 16,098
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup."


Was that also a failure?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1590360
Posted Tuesday, July 8, 2014 7:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 14,205, Visits: 28,534
SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup."


Was that also a failure?


Depending on my mood and the attitude of the person receiving, that can be a partial failure, if you know what I mean.


----------------------------------------------------
"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
Post #1590366
Posted Tuesday, July 8, 2014 8:18 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup."


Was that also a failure?


Heh... no. I studied real hard on how to do it without getting my hands wet.


--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 #1590388
Posted Tuesday, July 8, 2014 12:05 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 18,064, Visits: 16,098
Jeff Moden (7/8/2014)
SQLRNNR (7/8/2014)
Jeff Moden (7/8/2014)
The first day was spent filling out paper work and peeing in a cup."


Was that also a failure?


Heh... no. I studied real hard on how to do it without getting my hands wet.


rofl




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1590459
Posted Friday, July 11, 2014 12:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 12:56 AM
Points: 210, Visits: 679
This has been one of my favorite question. There are no right or wrong answers i expect. I just look for these points

- problem solving approach
- Ownership, candidates role in solving the problem
- attitude towards problem
- homework or knowledge gather regarding the issue
- what step were take to make sure problem doesnt happen again
- communication skills


Cheers
Post #1591442
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse