Search results matching tags 'SQL 2012' and 'PASS'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=SQL+2012,PASS&orTags=0Search results matching tags 'SQL 2012' and 'PASS'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Building Your T-SQL Tool Kit: Window Function Fundamentalshttp://sqlblog.com/blogs/sergio_govoni/archive/2014/01/21/building-your-t-sql-tool-kit-window-function-fundamentals.aspxTue, 21 Jan 2014 19:40:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:52421Sergio Govoni<p>The session <a href="http://www.youtube.com/watch?v=tUK3ohs7uDI&amp;list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC" target="_blank" mce_href="http://www.youtube.com/watch?v=tUK3ohs7uDI&amp;list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC">Building Your T-SQL Tool Kit: Window Function Fundamentals</a>&nbsp;by Christina E. Leo (<a href="https://twitter.com/christinaleo" target="_blank" mce_href="https://twitter.com/christinaleo">@christinaleo</a>) has been published on&nbsp;channel <a href="http://www.youtube.com/user/SQLPASSTV" target="_blank" mce_href="http://www.youtube.com/user/SQLPASSTV">SQLPASS TV</a>.</p>
<p><a href="http://www.youtube.com/watch?v=tUK3ohs7uDI&amp;list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC" target="_blank" mce_href="http://www.youtube.com/watch?v=tUK3ohs7uDI&amp;list=PLoGAcXKPcRvbTr23ujEN953pLP_nDyZJC"><img width="397" height="295" style="width:397px;height:295px;" src="http://sqlblog.com/files/folders/52422/download.aspx"></a></p>
<p><b>Abstract</b></p>
<p>Have you pulled a script to identify duplicates from a blog post but couldn't quite get it to work because you weren't sure what that ROW_NUMBER() function was doing? Maybe you heard talk about creating running totals without using subqueries, but you got frustrated when the groups weren't totaling correctly. Or maybe, you've never even heard of window functions. All are good reasons to attend this all-demo session, which demystifies this versatile T-SQL tool. First, we'll break apart the OVER clause, the key to understanding how window functions work. Then we'll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we'll look at real scenarios where this tool works and talk about performance considerations. When you leave, you'll have the fundamentals you need to fully develop your mastery of window functions.</p>
<p>Enjoy!</p>September 12 in San Franhttp://sqlblog.com/blogs/rick_heiges/archive/2012/09/11/september-12-in-san-fran.aspxWed, 12 Sep 2012 02:04:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:45151RickHeigesJust a reminder that I will be speaking at the SF UG SQL Server User Group on Sep 12.&nbsp; Here is a <a title="link" href="http://www.meetup.com/The-San-Francisco-SQL-Server-Meetup-Group/events/75363462/" target="_blank">link</a> with all of the details.&nbsp; If you are in the area, It would be great to see you!