Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Nakul Vachhrajani » Fun with IDENTITY - Part II
Add to briefcase
28 posts, Page 3 of 3
«««123

Fun with IDENTITY - Part II Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
L' Eomot Inversé
Posted Friday, October 08, 2010 5:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:53 PM
Points: 7,182, Visits: 7,281
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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

http://es.linkedin.com/in/tomthomsonsoftware
Post #1001183
UMG Developer
Posted Friday, October 08, 2010 9:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 2,163, Visits: 2,150
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
Kevin Gill
Posted Friday, October 08, 2010 10:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 07, 2013 4:08 AM
Points: 941, Visits: 239
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
paul.goldstraw
Posted Monday, October 11, 2010 2:45 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 9:52 AM
Points: 814, Visits: 1,137
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
Koen Verbeeck
Posted Monday, October 11, 2010 3:03 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 9,410, Visits: 6,495
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
paul.goldstraw
Posted Monday, October 11, 2010 3:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 9:52 AM
Points: 814, Visits: 1,137
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
deepak.a
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: Monday, August 13, 2012 10:04 AM
Points: 554, Visits: 861
thanks for the good question
Post #1006054
natalie.ignatieva
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: Yesterday @ 9:53 AM
Points: 236, Visits: 245
Great question, thank you!
Post #1011906
« Prev Topic | Next Topic »

Add to briefcase
28 posts, Page 3 of 3
«««123

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.