Wayne Sheffield

My blog about SQL Server

Actually, I only submitted the winning entry; Denali CTP3 SQL Server 2012 is the real winner. After having a blog posted here recently about running totals performance in Denali CTP3 SQL Server 2012, I happened to run across this T-SQL Challenge for doing running totals. On a lark, I posted a Denali CTP3 SQL Server […]

Recap of my first ever SQL PASS Summit – 2011: Saturday, Oct 8 – Travel day – I flew from Richmond VA to the Seattle / Tacoma International airport via Atlanta. The flight arrived early… 11:20pm (that’s 2:20am EST… yuck). Other than being in the airline system for 12 hours, it was pretty non-eventful. (But […]

There is something wrong in the SQL force today… here it is the first Tuesday of a month, and we’re doing a T-SQL Tuesday. There was another recent disturbance in the SQL force when we had a T-SQL Wednesday. Oh my, the SQL force is having a lot of recent disturbances. The good news is […]

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 article The OVER Clause enhancements in […]

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 article The OVER Clause enhancements in […]

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, so code that performs Row-By-Agonizing-Row (RBAR) […]

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 article The OVER Clause enhancements in […]

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 article The OVER Clause enhancements in […]

♠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 adhere to the ANSI specification, […]

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 designed for set-based operations, so code […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close