Leaving the Windows Open
Computing running totals, averages by state or group, and other complex aggregations are not easy to implement in many relational databases. Thankfully, many relational databases include support for window functions. Window functions are an extension to the ANSI SQL standard. More than just another part of SQL, window functions enable complex ranking, ordering, and other aggregations over a subset of rows in a query. Understanding the capabilities of window functions lets you extend application functionality, build rich and complex queries, and reduce overhead in the application tier.
Jeremiah Peschka (Twitter) helps developers, DBAs, and engineers build faster, robust, and scalable solutions; Microsoft SQL Server is frequently a part of that solution, but other databases are also. He has worked as a database and emerging technology expert at Quest Software researching new trends and technologies around data storage. Before that Jeremiah worked across many industries as a system administrator, developer, and DBA, and has been involved in all aspects of application development and deployment.
Jeremiah is a principle with Brent Ozar -PLF.
Refreshments provided by Apex Systems, Inc..
Jobs, Jobs, Jobs …
- The SQL Server related job market has really taken off in the past few months. Currently, there are approximately 30 open positions (Admins, Developers, BI -from entry to advanced skills) in the Oregon/SW Washington region. Check out the Oregon SQL Jobs page. Tell your friends and colleagues to regularly visit the Jobs page.
Featured Sponsor: VanderHouwen & Associates (VHA)
- For over two decades, VHA has been a premier staffing provider of technology professionals in the Pacific Northwest. We have since expanded to provide professional accounting placement services. While it might seem unusual for a rapid-deploy, results-driven business like ours to take that responsibility personally, we do. Our President’s work ethic not only serves as the foundation of our company, but drives the commitment to individual attention which infuses our culture. We are dedicated to the satisfaction and success of our clients and consultants. We are committed to providing outstanding service to a uniquely demanding industry in a straightforward, ethical, highly personal, and always-responsive manner.
For more information, visit our website.
We wish to acknowledge Robert Half Technologies for supporting Oregon SQL by generously sponsoring the meeting venue.