Search

Top 60 Oracle Blogs

Recent comments

SQL Server

You've Got Framing

The framing clause brings the "window" to window functions. It's an ideal
solution when you can arrange a business question such that an answer comes
from applying an aggregate function to a range...



Read the full post at www.gennick.com/database.

Pulling Rank for the Boss

Look to ROW_NUMBER, RANK, and DENSE_RANK anytime you are faced with a
business question involving words or phrases such as "topmost" or
"bottommost", "top N" or "bottom N", or that is otherwise...



Read the full post at www.gennick.com/database.

Pulling Rank for the Boss

Look to ROW_NUMBER, RANK, and DENSE_RANK anytime you are faced with a
business question involving words or phrases such as "topmost" or
"bottommost", "top N" or "bottom N", or that is otherwise...



Read the full post at www.gennick.com/database.

Interlude

Having the right mental model of how window functions operate goes a long
way toward recognizing when and how to apply these functions that can seem
almost magical in the expressive power.



Read the full post at www.gennick.com/database.

Interlude

Having the right mental model of how window functions operate goes a long
way toward recognizing when and how to apply these functions that can seem
almost magical in the expressive power.



Read the full post at www.gennick.com/database.

H. G. Wells and SQL: Traveling in the Second Dimension

SQL is traditionally one-dimensional in that you can access values in a
row, in the horizontal dimension. SQL Server 2012's support of LAG and LEAD
and other so-called window functions open up the...



Read the full post at www.gennick.com/database.

H. G. Wells and SQL: Traveling in the Second Dimension

SQL is traditionally one-dimensional in that you can access values in a
row, in the horizontal dimension. SQL Server 2012's support of LAG and LEAD
and other so-called window functions open up the...



Read the full post at www.gennick.com/database.

Detail in the Aggregate

SQL Server 2012 – the "Denali" release – brings improved support for window
functions as defined in the SQL standard. One of the things you can now do
is to mix summary and detail results in the...



Read the full post at www.gennick.com/database.

Detail in the Aggregate

SQL Server 2012 – the "Denali" release – brings improved support for window
functions as defined in the SQL standard. One of the things you can now do
is to mix summary and detail results in the...



Read the full post at www.gennick.com/database.

Thirteen signs of DBA fudging

If you are a director, manager or project manager who works with DBAs, you probably have had the nagging suspicion at one time or another that a DBA’s assertions regarding his or her practices lack an empirical or scientific basis, or are simply deflections intended to pass the buck.

Manager: Mr. DBA, the application is really slow. Do you have any idea what’s wrong?

DBA: Oracle is very complex. It could be any of 100 different possible causes. I will begin checking each. Anyhow, what makes you think it is the database?