Page considered Suspect in SQL Server 2017

  • Junior Galvão - MVP

    SSCertifiable

    Points: 6366

    Comments posted to this topic are about the item Page considered Suspect in SQL Server 2017

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71257

    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”

  • HappyGeek

    SSCoach

    Points: 18657

    Good question, thanks Steve.

    ...

  • Carlo Romagnano

    SSC-Insane

    Points: 21692

    Stewart "Arturius" Campbell - Monday, May 21, 2018 11:27 PM

    Had to read up on this (haven't dealt with suspect databases for quite a while).
    Interesting question, thanks Steve

    Thanks Junior Galvão

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    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

  • NorthernSoul

    SSCertifiable

    Points: 6765

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    I agree, it caught me out too.

    Thanks

  • paul s-306273

    SSChampion

    Points: 10530

    HappyGeek - Tuesday, May 22, 2018 12:49 AM

    Good question, thanks Steve.

    Not Steve.

  • HappyGeek

    SSCoach

    Points: 18657

    paul s-306273 - Tuesday, May 22, 2018 3:37 AM

    HappyGeek - Tuesday, May 22, 2018 12:49 AM

    Good question, thanks Steve.

    Not Steve.

    Yeah realised too late, thanks for the correction and thanks to Junior for the question!

    ...

  • x

    SSC-Insane

    Points: 23349

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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!!!!

  • Sean Lange

    SSC Guru

    Points: 286402

    patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AM

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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/

  • x

    SSC-Insane

    Points: 23349

    Sean Lange - Tuesday, May 22, 2018 7:20 AM

    patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AM

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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 🙁

  • Sean Lange

    SSC Guru

    Points: 286402

    patrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AM

    Sean Lange - Tuesday, May 22, 2018 7:20 AM

    patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AM

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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/

  • John Mitchell-245523

    SSC Guru

    Points: 148246

    Sean Lange - Wednesday, May 23, 2018 8:02 AM

    patrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AM

    Sean Lange - Tuesday, May 22, 2018 7:20 AM

    patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AM

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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

  • Sean Lange

    SSC Guru

    Points: 286402

    John Mitchell-245523 - Wednesday, May 23, 2018 8:11 AM

    Sean Lange - Wednesday, May 23, 2018 8:02 AM

    patrickmcginnis59 10839 - Wednesday, May 23, 2018 7:36 AM

    Sean Lange - Tuesday, May 22, 2018 7:20 AM

    patrickmcginnis59 10839 - Tuesday, May 22, 2018 6:24 AM

    NorthernSoul - Tuesday, May 22, 2018 3:17 AM

    John Mitchell-245523 - Tuesday, May 22, 2018 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

    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/

  • HappyGeek

    SSCoach

    Points: 18657

    Sean Lange - Wednesday, May 23, 2018 11:01 AM

    John Mitchell-245523 - Wednesday, May 23, 2018 8:11 AM

    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.

    +1

    ...

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply