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: Yesterday @ 8:06 PM
Points: 36,786, Visits: 31,243
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


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:10 AM
Points: 21,311, Visits: 14,995
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1590360
Posted Tuesday, July 8, 2014 7:53 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 15,556, Visits: 27,928
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
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: Yesterday @ 8:06 PM
Points: 36,786, Visits: 31,243
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


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 10:10 AM
Points: 21,311, Visits: 14,995
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1590459
Posted Friday, July 11, 2014 12:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 191, Visits: 590
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,
Ankur
Post #1591442
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse