June 3, 2013 at 1:26 am
PLease tell me what is the Query Recasting
June 3, 2013 at 3:03 am
Never heard of query recasting. What's the context?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2013 at 6:40 am
In SQL or Dataware housing , this question asked in interview
June 3, 2013 at 6:48 am
Maybe it was a trick question.
June 3, 2013 at 7:07 am
Ed Wagner (6/3/2013)
Maybe it was a trick question.
Maybe a question designed to see whether the candidate will admit they don't know or try to make up something.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2013 at 8:41 am
I've actually used this tactic in conducting interviews. I felt that some people were trying to bluff their way through the technical portion of the interview so I threw in a trick question to quantify my suspicions. I asked if they'd ever used table-valued parameters in SQL 2005. If they just said "Yes" without explaining the workaround they used, I knew they were scamming the interview.
I've got to believe I'm not the only one to think of this.
June 3, 2013 at 8:49 am
Ed Wagner (6/3/2013)
I've actually used this tactic in conducting interviews. I felt that some people were trying to bluff their way through the technical portion of the interview so I threw in a trick question to quantify my suspicions. I asked if they'd ever used table-valued parameters in SQL 2005. If they just said "Yes" without explaining the workaround they used, I knew they were scamming the interview.
Same. Like asking how many GAM pages you would find in a 7GB transaction log file. I just want to see if the person can admit that they don't know.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2013 at 9:04 am
could it be this?
'Recasting in this context is the process of changing the data type of a column value from one type to another.'
June 3, 2013 at 9:06 am
GilaMonster (6/3/2013)
Ed Wagner (6/3/2013)
I've actually used this tactic in conducting interviews. I felt that some people were trying to bluff their way through the technical portion of the interview so I threw in a trick question to quantify my suspicions. I asked if they'd ever used table-valued parameters in SQL 2005. If they just said "Yes" without explaining the workaround they used, I knew they were scamming the interview.Same. Like asking how many GAM pages you would find in a 7GB transaction log file. I just want to see if the person can admit that they don't know.
I like asking if they are familiar with querying the transaction log so they can rollback a transaction that was committed in error.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply