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 «««4,3404,3414,3424,3434,344»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, March 24, 2014 1:57 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:10 PM
Points: 680, Visits: 6,862
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.

WOW! Now that's enough to scare anyone. Just think...he has access to the server.


Who will be the brave one to ask how recent the bak file is?
Or how he became a DBA?
Takes a lot to scare some of you guys.
And there is quite a bit there.
Post #1554207
Posted Monday, March 24, 2014 3:11 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: Yesterday @ 9:29 AM
Points: 40,656, Visits: 37,115
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.


And he sent me a PM asking if I'd assist with getting the system back up and running. Even if I was still consulting I suspect the answer would be "No."



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 #1554223
Posted Monday, March 24, 2014 3:14 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: Yesterday @ 9:29 AM
Points: 40,656, Visits: 37,115
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.

WOW! Now that's enough to scare anyone. Just think...he has access to the server.


It's probably nothing more than a case of "Why's the <app which has been working for years> not working? What do you mean 'who's the administrator'? We've never needed an administrator before. Hey <random person in office>, get this thing working NOW."



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 #1554226
Posted Monday, March 24, 2014 3:20 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Monday, December 22, 2014 3:26 AM
Points: 14,205, Visits: 28,536
GilaMonster (3/24/2014)
Ed Wagner (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.

WOW! Now that's enough to scare anyone. Just think...he has access to the server.


It's probably nothing more than a case of "Why's the <app which has been working for years> not working? What do you mean 'who's the administrator'? We've never needed an administrator before. Hey <random person in office>, get this thing working NOW."


Yep. That moment when everyone around you steps back from the line.


----------------------------------------------------
"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 #1554230
Posted Monday, March 24, 2014 3:24 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:10 PM
Points: 680, Visits: 6,862
GilaMonster (3/24/2014)
Lynn Pettis (3/24/2014)
I don't know why, but this sort of thing scares me.


And he sent me a PM asking if I'd assist with getting the system back up and running. Even if I was still consulting I suspect the answer would be "No."


I wanted to see why he said the .bak file was corrupt.
There is the (remote) possibility that it was OK, he just didn't know how to use it.

Although I totally agree - he needs someone local so he could watch them see if / how they can fix it.

Hoping that he was volunteered for the DBA job.
It would be really scary if he was hired through any kind of interview process.
Post #1554234
Posted Tuesday, March 25, 2014 2:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 22, 2014 6:50 AM
Points: 7,057, Visits: 7,288
GilaMonster (3/24/2014)
It's probably nothing more than a case of "Why's the <app which has been working for years> not working? What do you mean 'who's the administrator'? We've never needed an administrator before. Hey <random person in office>, get this thing working NOW."


Welcome to my world



Far away is close at hand in the images of elsewhere.

Anon.

Post #1554319
Posted Tuesday, March 25, 2014 7:30 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 5,370, Visits: 9,017
Greg Edwards-268690 (3/24/2014)

It would be really scary if he was hired through any kind of interview process.


But... I've been working in SQL for 10 years... I'm a senior DBA!


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1554457
Posted Tuesday, March 25, 2014 8:16 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 2:10 PM
Points: 680, Visits: 6,862
WayneS (3/25/2014)
Greg Edwards-268690 (3/24/2014)

It would be really scary if he was hired through any kind of interview process.


But... I've been working in SQL for 10 years... I'm a senior DBA!


My computer at work turns on and boots up when I press the power button in the morning.
I am a Certified Professional in all things computer related!

A few more years of walking by the server room, and I can add Network Admin to my credentials!
Gotta love how easily I gain additional skills.

Does it help if I know someone who knows the few things I don't know yet?
Then I could progress even faster.

Speaking of progress, know of any jobs?
Seems I'm ready for a move.
Things are kind of chaotic here for some reason.
Post #1554493
Posted Tuesday, March 25, 2014 5:51 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:40 AM
Points: 3,443, Visits: 5,404
Greg Edwards-268690 (3/25/2014)
WayneS (3/25/2014)
Greg Edwards-268690 (3/24/2014)

It would be really scary if he was hired through any kind of interview process.


But... I've been working in SQL for 10 years... I'm a senior DBA!


My computer at work turns on and boots up when I press the power button in the morning.
I am a Certified Professional in all things computer related!

A few more years of walking by the server room, and I can add Network Admin to my credentials!
Gotta love how easily I gain additional skills.

Does it help if I know someone who knows the few things I don't know yet?
Then I could progress even faster.

Speaking of progress, know of any jobs?
Seems I'm ready for a move.
Things are kind of chaotic here for some reason.


Alas, based on comparing the contents of some resumes I've seen with their actual capabilities as uncovered during an interview, that is too true.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1554726
Posted Tuesday, March 25, 2014 6:13 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 2,787, Visits: 6,098
My poster child interview disappointment: Good resume' on paper, but then the man walked in, opened up his laptop, and scrolled through a "cheat sheet" document each time he was asked a question. He rarely made eye contact as he paged up and down searching for answers. When his answers were so off base that we rephrased questions, he would argue that he had already answered them. Go figure.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills
Post #1554728
« Prev Topic | Next Topic »

Add to briefcase «««4,3404,3414,3424,3434,344»»»

Permissions Expand / Collapse