SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Follow Up To A Questionable Trigger

This question of the day didn’t turn out well at all – required too big a leap the way it was written to get to the key answer. Four were easy, one was not. I confused the issue with a less than great trigger – not deliberately, sadly. The lesson – learning it again – it to think about what assumptions I’m asking them to make to get to the right answer and whether those assumptions are realistic. That’s hard, because I know the angles of the question. It’s also an illustration that it’s not the easiest thing in the world to take a lesson learned at work and convert it to a good question. The associated discussion is really good. They do give me some grief (deserved), but more it’s helpful feedback. One more reason I think QOD’s are good writing practice.

 

image

SQLAndy

I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Comments

Leave a comment on the original post [sqlandy.com, opens in a new window]

Loading comments...