THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » OVER clause   (RSS)
  • Give speakers feedback. It makes a difference.

    I sometimes struggle with finding a catchy title for a blog post. It has to grab the attention, and clarify what the post is about. If you decided to spend time reading my words, I do not want you to finish ending “if I had known this was the content, I would have done something better with my time”. For this post, I think the title just sums up ...
  • SQLRally and SQLRally - Session material

    I had a great week last week. First at SQLRally Nordic, in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into SQLRally Amsterdam, where I delivered a session on the performance implications of using user-defined functions ...
  • TechEd 2010 Thanks and Demos

    Thank you to everyone who attended my three sessions at this year's TechEd show in New Orleans. I had a great time presenting and answering the really great questions posed by attendees. My sessions were: DAT317 T-SQL Power! The OVER Clause: Your Key to No-Sweat Problem SolvingHave you ever stared at a convoluted requirement, unsure of where to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 10, 2010
  • Please Vote: Windowing Enhancements in SQL Server

    Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 19, 2009
  • Demos: Connections, Fall 2009, Las Vegas

    Thanks to everyone who attended my sessions this week at SQL Server Magazine Connections in Las Vegas. Attached to this post you will find the demos for the following sessions: SDV301: Best Practices for Exception Handling and Defensive Programming in SQL Server 2005 and 2008As developers, we sometimes become lax about dealing with error ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on November 12, 2009
  • Demos From Cape Cod .NET: T-SQL Power! Presentation

    On Tuesday night I was honored to present a new talk to the Cape Cod .NET Users Group that meets in Plymouth, MA. The talk is called ''T-SQL Power! Learning to Harness the Under-Used OVER Clause''. Following is the abstract for the talk:First introduced in SQL Server 2005, the OVER clause is an ANSI SQL enhancement that gives you tremendous ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 18, 2009
Privacy Statement