Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield The OVER Clause enhancements in SQL Server code named “Denali”, CTP3 RE: The OVER Clause enhancements in SQL Server code named “Denali”, CTP3

  • August 25, 2011 at 9:23 am

    #1373249

    HowardW (8/25/2011)

    Nice blog post Wayne - shame the performance doesn't look great at the moment for a common use-case. Hope they sort it out before RTM - I don't recall the Oracle version having any huge performance hit on the windowing functions, so not sure there's a major architectural reason it has to have so many reads

    Thanks Howard.

    I also am hoping that it's just debug/beta code causing the issues.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2