August 12, 2013 at 11:18 pm
Comments posted to this topic are about the item SSIS 2012 -SSISDB
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
August 12, 2013 at 11:52 pm
Easy one thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 2:15 am
This was removed by the editor as SPAM
August 13, 2013 at 6:40 am
Silly semantics....
Being able to have only one catalog is still technically having one or more catalogs 🙂
August 13, 2013 at 7:40 am
I don't even have 2012 installed yet, so I did some research, and found:
"A folder contains one or more projects and environments in the SSISDB catalog."
http://technet.microsoft.com/en-us/library/hh479588.aspx
but the answer to the QOTD says zero.
so who is right?
August 13, 2013 at 7:50 am
TaylorMade (8/13/2013)
I don't even have 2012 installed yet, so I did some research, and found:"A folder contains one or more projects and environments in the SSISDB catalog."
http://technet.microsoft.com/en-us/library/hh479588.aspx
but the answer to the QOTD says zero.
so who is right?
You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.
August 13, 2013 at 8:20 am
mtassin (8/13/2013)
TaylorMade (8/13/2013)
I don't even have 2012 installed yet, so I did some research, and found:"A folder contains one or more projects and environments in the SSISDB catalog."
http://technet.microsoft.com/en-us/library/hh479588.aspx
but the answer to the QOTD says zero.
so who is right?
You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.
What does the word "should" mean? It doesn't mean the same as "can", that's for sure. Could the use of "should" with "one or more" versus the use of "can" with zero or more" be an attempt to produce a nasty trick question? If not, why are the two words used? Does the author think "should" means "must always"?
Both "a folder should contain one or more..." and "a folder can contain zero or more..." are correct - the whole point of a folder is to contain projects and environments, so it should contain a project; but they don't have to contain one all the time, that would make creation too complex, which is why "should".
The same applies to "catalog should have one or more folder" and "catalog can have one or more folders": both are correct.
I got this one wrong because I picked the wrong selection from each of the two both correct pairs. I suspect that's because of a language difference.
Tom
August 13, 2013 at 8:39 am
L' Eomot Inversé (8/13/2013)
mtassin (8/13/2013)
TaylorMade (8/13/2013)
I don't even have 2012 installed yet, so I did some research, and found:"A folder contains one or more projects and environments in the SSISDB catalog."
http://technet.microsoft.com/en-us/library/hh479588.aspx
but the answer to the QOTD says zero.
so who is right?
You have to create the folder before you can push a project to it. When you create the folder it has zero projects in it, and if you create a few folders at the start, they can still exist with zero projects in them.
What does the word "should" mean? It doesn't mean the same as "can", that's for sure. Could the use of "should" with "one or more" versus the use of "can" with zero or more" be an attempt to produce a nasty trick question? If not, why are the two words used? Does the author think "should" means "must always"?
Both "a folder should contain one or more..." and "a folder can contain zero or more..." are correct - the whole point of a folder is to contain projects and environments, so it should contain a project; but they don't have to contain one all the time, that would make creation too complex, which is why "should".
The same applies to "catalog should have one or more folder" and "catalog can have one or more folders": both are correct.
I got this one wrong because I picked the wrong selection from each of the two both correct pairs. I suspect that's because of a language difference.
I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....
August 13, 2013 at 8:39 am
dhober (8/13/2013)
Silly semantics....Being able to have only one catalog is still technically having one or more catalogs 🙂
That kind of thinking can get you into a lot of trouble. Just imagine that thinking on Regex...
August 13, 2013 at 8:57 am
cschlieve (8/13/2013)
dhober (8/13/2013)
Silly semantics....Being able to have only one catalog is still technically having one or more catalogs 🙂
That kind of thinking can get you into a lot of trouble. Just imagine that thinking on Regex...
+1
August 13, 2013 at 9:37 am
Nice Question! -1:doze:
Best,
Naseer Ahmad
SQL Server DBA
August 13, 2013 at 10:30 am
I learned something with this question but had to do some extra interpretation to get the intended answers. I think it would have been better had the author avoided the word "should" and possibly changed those other answer choices to use "must" (as in, a folder must have one or more projects). This would have made some of the answer choices more exclusive in my opinion.
The word "should", to me, implies an opinion and for a QoTD would usually be used more in a best practices scenario such as "Backups should be taken and tested on a regular basis" or something to that effect. Backups certainly do not need to be taken but I think everyone would agree that they should be taken. I only bring this up in the event that this wording was chosen due to a language barrier more so than as an attempt at tricking the readers. 🙂
August 13, 2013 at 1:08 pm
batgirl (8/13/2013)
I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....
I think it's far more likely to be a language issue that an attempt to trick.
Probably if I had seen the author's name before looking at the question I would have said to myself "Aha, there may be some Indian English here" and watched out for things like "should" having a different meaning; Indian English and Scottish English (the best English :-D) are not the same, any more than American English and Scottish English are, or Australian English and American English.
Tom
August 13, 2013 at 1:20 pm
L' Eomot Inversé (8/13/2013)
batgirl (8/13/2013)
I fully appreciate the efforts of the author - the bottom line is that this question forced me to learn something new. I just wish it were possible to eliminate the "fuzzy" answer choices here. In the grand scheme of things, I think some of these choices are important to know and others are less so. Ultimately it feels like an attempt to trick....I think it's far more likely to be a language issue that an attempt to trick.
Probably if I had seen the author's name before looking at the question I would have said to myself "Aha, there may be some Indian English here" and watched out for things like "should" having a different meaning; Indian English and Scottish English (the best English :-D) are not the same, any more than American English and Scottish English are, or Australian English and American English.
I agree that it wasn't likely a deliberate attempt to trick me...it just take so little some days 😛
August 21, 2013 at 9:56 pm
I had to dig a bit to figure this one out. Thanks for the opportunity
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply