1. Using the OVER clause with aggregate functions
The following sample is from BOL:
-------------------------------------
USE AdventureWorks2008R2;
GO
SELECT SalesOrderID, ProductID, OrderQty
,SUM(OrderQty) OVER(PARTITION BY...
2012-06-30
2,617 reads
Let’s say that you are in the market to buy a new laptop or ultra book to replace that old...
2012-06-30
2,322 reads
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
8,981 reads
I have two goals that I have sought to achieve by mid-year of 2012. The deadline I set for myself...
2012-06-29
1,475 reads
You have until July 6 to enter to win a free seat at the SQLskills Internals and Performance (IE1) training...
2012-06-29
1,704 reads
I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned...
2012-06-28 (first published: 2012-06-25)
3,784 reads
This week I have two presentations on my schedule. I get to give my Performance Tuning for Pirates presentation twice...
2012-06-28
1,388 reads
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,727 reads
Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...
2012-06-28
1,553 reads
Four more speakers we’re pleased to have joining us at SQLSaturday #151 this fall in Orlando!
Paul Waters
Mike Antonovich
David Liebman
Bradley Schacht
2012-06-28
1,396 reads
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers