So here's a scenario. You have a client that has implemented SAN storage for your SQL Servers (could be virtual or physical). Your manager tells you that ever since the SAN team got involved things are running slower! And He's sure it's a SAN problem.
This past Tuesday I had the privilege of attending the NJ SQL PASS Group meeting in Wayne, NJ. It's typically held at the Microsoft Store in the Willow brook Mall. In the back, they have a huge screen which lends itself nicely for presentations.
The OVER clause was first introduced to us in SQL 2005. It is often used as a supplement to other functions to provide which rows from a particular query are applied to a function. It is usually presented as part or in addition to an existing result set.