May 21, 2018 at 11:25 pm
Comments posted to this topic are about the item Page considered Suspect in SQL Server 2017
May 21, 2018 at 11:27 pm
Had to read up on this (haven't dealt with suspect databases for quite a while).
Interesting question, thanks Junior
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
May 22, 2018 at 12:49 am
Good question, thanks Steve.
...
May 22, 2018 at 3:01 am
Stewart "Arturius" Campbell - Monday, May 21, 2018 11:27 PMHad to read up on this (haven't dealt with suspect databases for quite a while).
Interesting question, thanks Steve
Thanks Junior Galvão
May 22, 2018 at 3:12 am
I think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.
John
May 22, 2018 at 3:17 am
John Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
May 22, 2018 at 3:37 am
HappyGeek - Tuesday, May 22, 2018 12:49 AMGood question, thanks Steve.
Not Steve.
May 22, 2018 at 3:47 am
paul s-306273 - Tuesday, May 22, 2018 3:37 AMHappyGeek - Tuesday, May 22, 2018 12:49 AMGood question, thanks Steve.Not Steve.
Yeah realised too late, thanks for the correction and thanks to Junior for the question!
...
May 22, 2018 at 6:24 am
NorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
May 22, 2018 at 7:20 am
patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AMNorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
But they are not all correct. Look closely at the last two.
Check_Alloc technically doesn't exist as there is no underscore but if were spelled correctly CHECKALLOC <> CHECKDB (But one portion of CHECKDB is to run CHECKALLOC). So that one is a bit of a stretch to not be considered a correct answer.
The last one though. RESTORE <> BACKUP.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 23, 2018 at 7:36 am
Sean Lange - Tuesday, May 22, 2018 7:20 AMpatrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AMNorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
But they are not all correct. Look closely at the last two.
Check_Alloc technically doesn't exist as there is no underscore but if were spelled correctly CHECKALLOC <> CHECKDB (But one portion of CHECKDB is to run CHECKALLOC). So that one is a bit of a stretch to not be considered a correct answer.
The last one though. RESTORE <> BACKUP.
He said they were all correct 🙂 But then he didn't give me my invisible internet points 🙁
May 23, 2018 at 8:02 am
patrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AMSean Lange - Tuesday, May 22, 2018 7:20 AMpatrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AMNorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
But they are not all correct. Look closely at the last two.
Check_Alloc technically doesn't exist as there is no underscore but if were spelled correctly CHECKALLOC <> CHECKDB (But one portion of CHECKDB is to run CHECKALLOC). So that one is a bit of a stretch to not be considered a correct answer.
The last one though. RESTORE <> BACKUP.
He said they were all correct 🙂 But then he didn't give me my invisible internet points 🙁
LOL you can have some of mine. I keep trying to trade them in for a tshirt or something but Steve never answers my plea. The question was a good one and the correct answers in the question are correct. But the explanation was a trainwreck for sure. Fortunately you have earned more points complaining about discussing not getting points then you would have received for the correct answer in the first place. 🙂
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 23, 2018 at 8:11 am
Sean Lange - Wednesday, May 23, 2018 8:02 AMpatrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AMSean Lange - Tuesday, May 22, 2018 7:20 AMpatrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AMNorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
But they are not all correct. Look closely at the last two.
Check_Alloc technically doesn't exist as there is no underscore but if were spelled correctly CHECKALLOC <> CHECKDB (But one portion of CHECKDB is to run CHECKALLOC). So that one is a bit of a stretch to not be considered a correct answer.
The last one though. RESTORE <> BACKUP.
He said they were all correct 🙂 But then he didn't give me my invisible internet points 🙁
The question was a good one and the correct answers in the question are correct.
Well, no, because the question says "which errors", and "a query has to read a page" isn't an error. That's what threw me.
John
May 23, 2018 at 11:01 am
John Mitchell-245523 - Wednesday, May 23, 2018 8:11 AMSean Lange - Wednesday, May 23, 2018 8:02 AMpatrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AMSean Lange - Tuesday, May 22, 2018 7:20 AMpatrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AMNorthernSoul - Tuesday, May 22, 2018 3:17 AMJohn Mitchell-245523 - Tuesday, May 22, 2018 3:12 AMI think I must have misunderstood something. The "Correct Answer" section lists the first three options as being the correct answers. The Explanation section then goes on to say "All the alternatives are correct". Not sure which one of those is true. Also, we're asked to choose three out of the five "errors", but only the first two of those five are actually errors.John
I agree, it caught me out too.
Thanks
If all of them were correct, why was selecting three of them wrong??!?!?! I think I should get double my points back!!!!
But they are not all correct. Look closely at the last two.
Check_Alloc technically doesn't exist as there is no underscore but if were spelled correctly CHECKALLOC <> CHECKDB (But one portion of CHECKDB is to run CHECKALLOC). So that one is a bit of a stretch to not be considered a correct answer.
The last one though. RESTORE <> BACKUP.
He said they were all correct 🙂 But then he didn't give me my invisible internet points 🙁
The question was a good one and the correct answers in the question are correct.
Well, no, because the question says "which errors", and "a query has to read a page" isn't an error. That's what threw me.
John
That is poor wording but it is copied exactly from BOL.
For that matter if we really want to get pedantic there is no wrong answer because the question states "Select the three alternatives that you consider to be correct". That could be interpreted as opinion and therefore there is no right or wrong answer. 😛
I think that we all agree the question topic was good but the question itself could have been better.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 23, 2018 at 11:06 pm
Sean Lange - Wednesday, May 23, 2018 11:01 AMJohn Mitchell-245523 - Wednesday, May 23, 2018 8:11 AMWell, no, because the question says "which errors", and "a query has to read a page" isn't an error. That's what threw me.John
That is poor wording but it is copied exactly from BOL.
For that matter if we really want to get pedantic there is no wrong answer because the question states "Select the three alternatives that you consider to be correct". That could be interpreted as opinion and therefore there is no right or wrong answer. 😛
I think that we all agree the question topic was good but the question itself could have been better.
+1
...
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply