Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2011

Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL Server “Denali”

All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my… Read more

0 comments, 2,251 reads

Posted in A Discussion of SQL Server-Related Topics on 22 September 2011

Analytic Functions – CUME_DIST / PERCENT_RANK

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL Server “Denali”

All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my… Read more

0 comments, 924 reads

Posted in A Discussion of SQL Server-Related Topics on 20 September 2011

Presenting Banish RBAR! to Hampton Roads UG

On Wednesday, Sept 21, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Hampton Roads SQL Server User Group. I’ll be presenting to the user group live, so this won’t be available online.

The abstract for this presentation is:

SQL Server is primarily designed for set-based operations,… Read more

0 comments, 295 reads

Posted in A Discussion of SQL Server-Related Topics on 19 September 2011

Analytic Functions – FIRST_VALUE / LAST_VALUE

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL Server “Denali”

All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my… Read more

0 comments, 1,167 reads

Posted in A Discussion of SQL Server-Related Topics on 15 September 2011

Analytic Functions – LAG / LEAD

This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.

Analytic Functions in SQL Server “Denali”

All of the new Analytic functions require the use of the OVER clause. To see what changes to the OVER clause that “Denali” brings, please view my… Read more

1 comments, 1,048 reads

Posted in A Discussion of SQL Server-Related Topics on 13 September 2011

Analytic Functions – Overview

?This post is the first post in a series discussing the new Analytic functions in SQL Server “Denali”, CTP3, and it will also serve as the landing page for this series.

(The information in this article may change when this version is released to RTM; however since the changes described… Read more

0 comments, 364 reads

Posted in A Discussion of SQL Server-Related Topics on 13 September 2011

Presenting Banish RBAR! at Richmond SQL UG

On Thursday, Sept 8, 2011 at 6:30pm EST, I’ll be presenting Banish RBAR! to the Richmond SQL Server User Group. The last time I presented here was the week of PASS Summit, so I’m hoping for a greater turnout.

The abstract for this presentation is:

SQL Server is primarily… Read more

0 comments, 284 reads

Posted in A Discussion of SQL Server-Related Topics on 7 September 2011