Avi1 - Tuesday, September 5, 2017 2:11 PM
Heh... on that note, I'll tell you that I stopped counting the number of supposedly senior DBAs with supposedly 10 years or more experience (many also claiming code performance tuning) at 20 out of 22 that didn't know how to get the current date and time using T-SQL. It's really amazing that anyone would claim to be a DBA and not know how to do that. I originally started asking the question as a non-threating, easy to answer, ice-breaker of a question to demonstrate that I don't ask trick or esoteric questions during a person's interview. It turned out to be a litmus strip test as for how the rest of the interview was going to go... mostly pitiful.
--Jeff Moden
Change is inevitable... Change for the better is not.