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 «««123

Fun with IDENTITY - Part II Expand / Collapse
Author
Message
Posted Friday, October 8, 2010 5:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:10 AM
Points: 8,826, Visits: 9,384
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
Post #1001183
Posted Friday, October 8, 2010 9:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,163, Visits: 2,191
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.
Post #1001413
Posted Friday, October 8, 2010 10:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:53 AM
Points: 1,105, Visits: 301
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!
Post #1001429
Posted Monday, October 11, 2010 2:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:44 AM
Points: 1,068, Visits: 1,432
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
Post #1001984
Posted Monday, October 11, 2010 3:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 13,724, Visits: 10,680
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1001991
Posted Monday, October 11, 2010 3:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:44 AM
Points: 1,068, Visits: 1,432
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.

Post #1001999
Posted Monday, October 18, 2010 3:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 2, 2014 9:57 AM
Points: 554, Visits: 863
thanks for the good question
Post #1006054
Posted Wednesday, October 27, 2010 3:08 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 271, Visits: 376
Great question, thank you!
Post #1011906
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse