March 11, 2011 at 2:12 am
Rune Bivrin (3/11/2011)
This question is just completely broken. There's a big difference between "preferred" and "valid". And to claim that varbinary(max) isn't a LOB is a bit daft.
QFT. Not to mention that it says "Select all that apply" and then gives you radio buttons, so you know it's only expecting one right answer...you just have to figure out which of the multiple possible right answers is the one it's looking for!
March 11, 2011 at 2:20 am
When we are to told to "Select all that apply" that means we are suppose to select all the correct answers. Hence providing radio buttons is not correct. Instead check boxes should have been provided.
OR the question should have said "Select any one of the correct answer" with radio buttons provided for answers.
March 11, 2011 at 2:59 am
Rant!!!!!!!
Ok I'm done :hehe:.
March 11, 2011 at 3:57 am
Relax, it's Friday, even for questions 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 11, 2011 at 4:04 am
Koen Verbeeck (3/11/2011)
Relax, it's Friday, even for questions 😀
Exactly. So, anyone doing anything interesting this weekend?
😎
March 11, 2011 at 4:33 am
Duncan Pryde (3/11/2011)
Koen Verbeeck (3/11/2011)
Relax, it's Friday, even for questions 😀Exactly. So, anyone doing anything interesting this weekend?
😎
Taking my motorcycle out for the first ride after the winter. 🙂
-Michael
BTW: Had the same issue with the radio buttons--so not sure how one was able to win the point anyway, as the 'correct answer' listed more than one data type...
March 11, 2011 at 4:40 am
Taking my fiancee out for her birthday 🙂
March 11, 2011 at 4:44 am
Wow, sounds like you're all having some fun this weekend!
I'm having the in-laws to stay, and taking some junk to the tip. Lucky me!
March 11, 2011 at 5:16 am
Working on demos and presentation for 24 hours of pass. Weekend, what weekend?
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
March 11, 2011 at 5:19 am
As already highlighted, Radio buttons and select all that apply don't kinda go together.
Hence I had a thought maybe "NOT" was missing from the question... so selected "Spatial"... should have left it on varchar(max)!
Poo... 🙁
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
March 11, 2011 at 5:57 am
Just a poorly worded question.. Poor choice for selection type and to me just a plain wrong answer.
March 11, 2011 at 6:18 am
select all that apply
and
radio buttons...
LMAO...too funny
I guess its done intentionally...lol
Regards,
Sushant
Regards
Sushant Kumar
March 11, 2011 at 6:30 am
Guys I think we should close on this now.
All of us are coming up with the same point that it is the issue of framing the question.
If anyone is sharing some knowledge that would be great for all of us.
I hope u all don't mind.
With Best Regards
🙂
March 11, 2011 at 6:56 am
I found this question to be very subjective, even the reference listed did not make a preferable option but listed them. If my data is in xml format then xml is preferred so .query .nodes can be used to interrogate the data.
March 11, 2011 at 7:35 am
stewartc-708166 (3/11/2011)
The options listed are classified as Large-Value data types, not LOB'srefer:
SQL2005: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.90).aspx
SQL2008: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.100).aspx
SQL2008R2: http://msdn.microsoft.com/en-us/library/ms178158(v=SQL.105).aspx
And yet this:
http://msdn.microsoft.com/en-us/library/ms187752.aspx
In SQL Server, based on their storage characteristics, some data types are designated as belonging to the following groups:
Large value data types: varchar(max), nvarchar(max), and varbinary(max)
Large object data types: text, ntext, image, varchar(max), nvarchar(max), varbinary(max), and xml
From the above one can conclude that varchat(max), nvarchar(max) and varbinary(max) are classified as being both. I guess we must have a data class known as chameleon except instead of changing color it changes what group it belongs to? ? ?
Viewing 15 posts - 16 through 30 (of 40 total)
You must be logged in to reply to this topic. Login to reply