PDW Transact-SQL compatibility with SMP

  • Hi,

    Hope it's the right forum!

    With PDW AU3, I know stored procedures are supported but some functions in the SMP SQL Server product have not been implemented in SQL Server PDW,

    Transact-SQL compatibility with SQL Server SMP is not yet fully complete and

    I'm looking for a documentation or something in order to help me.

    Who knows where I can find info. about what is supported or not ?

    Thank you

  • By "PDW" can we assume that you mean the Parallel Data Warehouse?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • htiteuf (5/23/2012)


    Hi,

    Hope it's the right forum!

    With PDW AU3, I know stored procedures are supported but some functions in the SMP SQL Server product have not been implemented in SQL Server PDW,

    Transact-SQL compatibility with SQL Server SMP is not yet fully complete and

    I'm looking for a documentation or something in order to help me.

    Who knows where I can find info. about what is supported or not ?

    Thank you

    The PDW documentation tells you what is supported. Talk to Microsoft or a PDW vendor representative and they should be able to help you. If you are considering PDW then I expect you will want to do a proof-of-concept implementation first so you will need to engage with the vendors to do that.

  • htiteuf (5/23/2012)


    With PDW AU3, I know stored procedures are supported but some functions in the SMP SQL Server product have not been implemented in SQL Server PDW, Transact-SQL compatibility with SQL Server SMP is not yet fully complete and I'm looking for a documentation or something in order to help me. Who knows where I can find info. about what is supported or not?

    You already asked this question on the MSDN forums and received an official answer from Microsoft.

  • SQL Kiwi (5/27/2012)


    htiteuf (5/23/2012)


    With PDW AU3, I know stored procedures are supported but some functions in the SMP SQL Server product have not been implemented in SQL Server PDW, Transact-SQL compatibility with SQL Server SMP is not yet fully complete and I'm looking for a documentation or something in order to help me. Who knows where I can find info. about what is supported or not?

    You already asked this question on the MSDN forums and received an official answer from Microsoft.

    You beat me to it Paul. As soon as I saw this thread in the email this morning I knew it was the same person.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • TheSQLGuru (5/28/2012)


    You beat me to it Paul. As soon as I saw this thread in the email this morning I knew it was the same person.

    The Internet is a small place 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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