• sql-lover (7/5/2014)

    I won't waste my time arguing with you. Your statements clearly shows you have zero working experience.[/QUOTE]

    OK - you got me 🙂

    sql-lover (7/5/2014)Moreover, based on your posts on this thread, you only posts to criticize, show others you're always right (when you are not) , and make theoretical statements all the time.

    You didn't answer my question:

    what benefit will have a PK here? Can you please explain in detail, what than will happen if SQL Server is using a PK?

    Instead of affronting you should be able to answer this depending on your experiences but try to avoid "theoretical" statements.

    So, what benefit will a PK have concerning the context you have described? I assume you have not read my posting complete.

    I'm not posting because of criticize people but if someone is giving wrong statements it maybe useful for others to point to the correct side.

    sql-lover (7/5/2014)Do us a favor. Take your MCM test again. You wasted your money and time.[/QUOTE]

    It is not possible because this program has retired. Here you err again 🙂

    And this has nothing to do with theoretical statements!

    Conclusion

    I try to reenforce my statements with theory and with practical examples. Your arguments (including the offence) seems to come to an end because you hedged arround but has not given valued answers which may convice me (or maybe others).

    Try it again - but without offence and clear examples - with sounded arguments and/or examples!

    If you cannot than let this thread go away into the endless of the internet 😉

    Microsoft Certified Master: SQL Server 2008
    MVP - Data Platform (2013 - ...)
    my blog: http://www.sqlmaster.de (german only!)