One useful feature in SQL Server is something called the OVER clause. The OVER clause has been available since SQL Server 2005 and allows you to perform window functions over a set of data. SQL Server provides two types of window functions: aggregate window functions and ranking window functions. I will explain what aggregate and ranking window functions are below. The Adventure Works sample database for SQL Server 2008 R2 will be used for all examples. This database models a retail store that sells biking products. Some may want to review the schema for AdventureWorks for better understanding.
Aggregate Window Functions
If you have used SQL’s GROUP BY clause, then you are probably familiar with aggregates. Aggregate functions allow you to perform a calculation over a set of data records. Each product sold by Adventure Works belongs to a subcategory which in turn…
For the past year or so I have been working on a web development project using Java. Like many Java projects, the project I was working on used 3rd party frameworks like Spring and Hibernate rather than utilizing the official Java EE stack. Many developers have turned to these frameworks because the official Java EE stack had been notoriously cumbersome and difficult to use. That is starting to change. Java EE 5 started moving Java EE in a new direction. Inspired by the ideologies of the 3rd party frameworks, the JCP, the standards community that works on the Java specification, began to make radical changes to the core of Java EE. These changes have continued in the latest iteration, Java EE 6.
Interested in comparing Java EE 6 to my experiences with Spring and Hibernate, I picked up a book on…
Welcome to the third and final installment of the jQuery saga. This post will cover some of the more advanced features of jQuery such as Ajax, utility functions and plugins. Along the way I will give examples that show how to use the functionality. I suggest that you read through the first two parts of my jQuery overview which cover the basics of jQuery before reading this post.
In addition to all of the goodness that jQuery provides that we covered in previous posts, jQuery also enables developers to easily make Ajax calls to a server. In this post we will cover a few of the different methods available for making asynchronous calls.
The first and simplest Ajax method that jQuery provides is the load() function. This function can be called on a jQuery wrapped set of elements and allows you to…
Welcome to the second part of my overview of jQuery. This article is part of a 3 part series. If you did not read the first article, you may want to go back and read that first. This article is going to pick up where the last article left off and cover more jQuery basics. Specifically, the events and effects functionality will be discussed. Afterwords, I will show some example code that utilizes many of the techniques that we have learned.
Event handling can sometimes be a problem when developing cross-browser applications. There are often at least two different ways of doing things depending on which browser is being used. jQuery helps us by abstracting the event handling logic. Behind the scenes jQuery will use feature detection to figure out which browser the code is being run on and then utilize…
The Unstandard Tag Library is a JSP tag library that was developed as part of the Jakarta Project. Its purpose is to provide a collection of useful tags that people have been requesting for JSTL. The library serves as a place to keep all of these tags until they are officially added to the Standard Tag Library. This article focuses on the use of one of the tags contained within the library, the useConstants tag.
While working on a project for a client, I realized that they were using a Java class with constants to define strings used within the application. The idea was to use the constants everywhere in the application where the strings were needed so they could easily be maintained in one location without having to search through the whole application when making a change. This makes…
Welcome to my first blog post on the topic of jQuery. This is the first part of a three part series. This post will cover most of the basic features of jQuery. The next post will wrap up the basic jQuery features and go through an example using what we learned. The final post will cover jQuery’s more advanced features and include another example.
What is jQuery?