SQL Server

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

JonathanGennick's picture

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.

oradebug's picture

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?

oradebug's picture

Finding non-default configuration settings in SQL Server

In our Remote DBA practice, we frequently perform comprehensive system reviews for our customers on their database services. Among the things we always check for are non-default settings for the database software. We want to validate that any non-default setting is set that way for a good reason, and that any setting that is default really should be that way.

In Oracle, this is easy.  The gv$parameter view has a column, ISDEFAULT, that allows a simple SQL query to show which settings are set to non-default values.

It’s not so easy in SQL Server.  There is a view, master.sys.configurations, but it doesn’t have a way to tell if the setting is default or modified or anything.

To prevent automated spam submissions leave this field empty.
Syndicate content