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


Fun with IDENTITY - Part II


Fun with IDENTITY - Part II

Author
Message
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26307 Visits: 12506
Kevin Gill (10/8/2010)
Didn't notice it was a table variable! Gah! :-)

Me too. That'll teach us to read more carefully!

Tom

UMG Developer
UMG Developer
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4104 Visits: 2204
Kevin Gill (10/8/2010)
Didn't notice it was a table variable! Gah! :-)


I almost didn't notice, and was think this is exactly the same as the question from a few days ago... So I brought up the old question and compared, and then the light went off and I knew how to answer it. :-)
Kevin Gill
Kevin Gill
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1349 Visits: 356
UMG Developer (10/8/2010)

I almost didn't notice, and was think this is exactly the same as the question from a few days ago...

I only tend to log on and answer a batch once every couple of weeks or so these days, and I end up doing them in reverse order! I got the other one right though :-)

-------------------------------
Oh no!
paul.goldstraw
paul.goldstraw
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1508 Visits: 1765
Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting, funny enough, a question on identity. The fact that the word identity doesn't appear anywhere in the explanation of the answer backs my opinion up that this was a sort of trick question. I have no problem with testing on the differences between temp tables and table variables and indeed, if the question had said it was related to that i would have got it right.

Sour grapes maybe, but I think questions should be about testing someone's knowledge, not their powers of observation.

Paul
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64060 Visits: 13298
paul.goldstraw (10/11/2010)
Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting, funny enough, a question on identity.


The fact that the titel of the question isn't highly correlated with the question itself, doesn't make it a poor question. I think that this question has alerted many people of the fact that they should be careful with table variables and transactions, thus making it a valuable question (but nothing to do with Identity, true true).

paul.goldstraw (10/11/2010)
Sour grapes maybe, but I think questions should be about testing someone's knowledge, not their powers of observation.


Well, the knowledge tested was table variables vs transactions. It is not really a tricky question because it is not just the @ sign that can tell you it is a table variable, but also the fact that a declare statement is used instead of a create table statement. Someone's observation skills must not be that strong (or reading the question with not enough attention) to miss that.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
paul.goldstraw
paul.goldstraw
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1508 Visits: 1765
da-zero (10/11/2010)
paul.goldstraw (10/11/2010)
Well it looks like i'm going to be in the minority by saying i think it was a poor question. I got it wrong because I was expecting, funny enough, a question on identity.


The fact that the titel of the question isn't highly correlated with the question itself, doesn't make it a poor question. I think that this question has alerted many people of the fact that they should be careful with table variables and transactions, thus making it a valuable question (but nothing to do with Identity, true true).

paul.goldstraw (10/11/2010)
Sour grapes maybe, but I think questions should be about testing someone's knowledge, not their powers of observation.


Well, the knowledge tested was table variables vs transactions. It is not really a tricky question because it is not just the @ sign that can tell you it is a table variable, but also the fact that a declare statement is used instead of a create table statement. Someone's observation skills must not be that strong (or reading the question with not enough attention) to miss that.


No, my observation skills aren't brilliant at 9am on a Monday, but I simply think they shouldn't have to be. Topics have titles and tags describing what they are testing for a reason. This question doesn't test anything at all to do with identities. It's not that it's more about table variables and transactions than identities, it's all about them. That is the reason why I believe it to be a poor question, not because of the question itself but because in the structure it is set it, I don't think it is unreasonable to expect the topic to bear some relation to the question, which this does not.

Just my opinion. Just a shame that the lesson I learned from this was not re. temp tables and table variables but to check whether the question even relates to the topic.
deepak.a
deepak.a
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1382 Visits: 863
thanks for the good question
natalie.ignatieva
natalie.ignatieva
Old Hand
Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)Old Hand (360 reputation)

Group: General Forum Members
Points: 360 Visits: 438
Great question, thank you!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search