Polybase SQL Server 2016

  • Comments posted to this topic are about the item Polybase SQL Server 2016

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • This was removed by the editor as SPAM

  • I had to research this one, so I learned something new. Good way to start the day, so thank you.

  • Great question. Did not know SQL 2016 was going to support Hadoop or Azure Blob storage. Not that I'll ever use it...

  • Sorry but the response of the Which server collations are supported in Polybase SQl Server 2016 in SQLServercental is wrong or they don't read MSDN. The correct answer is what I selected:

    Latin1_General_100_CI_AS_KS_WS

    In the future please investigate more thoroughly the correct answer to your QOD.

  • Sorry guys and gals but I am really sad to find that so many wrong answers I am finding lately for the QOD (Question of the day). It would make me extremely happy if anyone before posting a QOD should thoroughly investigate what is the correct answer to their QOD. I have 25 years of experience and have all the wallpapers (MS Certifications) can be obtained in the SQL Server's field plus Bachelor of Computer Science Degree and I feel I know what I am talking about. I would never bother to post a QOD if I would not have the correct answer. Dear fellow members please take this to into your account before post a QOD in this site.

    Regards from a frustrated member.

  • julienchappel 38298 (7/22/2015)


    Sorry but the response of the Which server collations are supported in Polybase SQl Server 2016 in SQLServercental is wrong or they don't read MSDN. The correct answer is what I selected:

    Latin1_General_100_CI_AS_KS_WS

    In the future please investigate more thoroughly the correct answer to your QOD.

    So on this page in Books Online, it literally says:

    Important

    In the CTP 2.0 (and later) versions, only these server collations are supported: SQL_Latin1_General_CP1_CI_AS (default US English collation) and Latin1_General_100_CI_AS_KS_WS.

    That's two collations. I checked those two, and the system told me I was right.

    Is it perhaps possible that you accidentally ticked only a single one of these collations? The way the SQL Server Central QotD works is that for a multi-answer question, you do not get partial points for a partially correct answer, you only get credit if you on a 100% match between your answer and the pre-sent "correct" answer. (Which, in this case, is indeed the correct answer).


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Good Question. Little knowledge on theoretical it needs but a nice question.

    Thanks.

  • It looks I will have to learn Hadoop, if only to be able to justify why I do not want to use it... 😉

    Thanks for the question, Kapil!

  • Nice question. Thank you.

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 11 posts - 1 through 10 (of 10 total)

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