Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

Question

Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

1) It is not a rumor - Denali will have more complete support for windowing functions, including those that allow for single-pass running totals.

2) Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated? And was is the next unknown flaw that has yet to be found? This isn't a bug in the engine that resulted in wrong answers but is now fixed so we are OK to proceed. You are rigging the system using incomplete knowledge and using mechanisms that are not (as has been proven time and again) guaranteed to provide the correct output. What is the next "rule" that will need to be added? How many people out there are using prior "rules collections" that are now invalidated but whom will not find out about this new flaw?

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 2

TheSQLGuru (7/4/2011)
Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated?

So, what's the flaw, Kevin?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

WayneS SSC Guru Points: 95460 More actions · Answer 3

Lynn Pettis (7/3/2011)
Is there a link to the updated code with saftey checks? I haven't been on ssc as much as I'd like to be so I think I may have missed part of this exchange of knowledge.

See http://www.sqlservercentral.com/Forums/FindPost980118.aspx and http://www.sqlservercentral.com/Forums/FindPost981258.aspx for the logic behind the safety check process.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 4

Jeff Moden (7/4/2011)
TheSQLGuru (7/4/2011)
Given that a flaw was found what, a two years or more, after the "quirky update" was first put out there how many incorrect results were calculated?
So, what's the flaw, Kevin?

The compute scalar one that Tom and Paul came up with a 'workaround' to address.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 5

Nope. The thing that Paul and Tom came up with is nothing more than an error checking method. It also happens to help guarantee functionality, but there was no flaw there and Paul didn't originally write it as a guarantee helper. Just a method for quickly doing the error checking instead of using a separate sproc to do the error checking.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)