# Challenging Yourself

• Comments posted to this topic are about the item Challenging Yourself

• I have to disagree a bit with the opening quote in the article.  My "wins" are learning episodes and so I'm always winning, not because I'm undershooting my potential, but because I'm always learning and increasing my potential.  I never fail because my failures are a learning experience,which help with my learning and that increases my potential and that always makes it a "win".

Here's an example that I created in code this very night... I created a Clustered Index with more than 99% fragmentation and the intentional scan of that index was almost twice as fast as two other indexes that contain exactly the same data with the same number of rows, both of which had only 0.36% logical fragmentation and close to 100% page density.  I scienced out the exact reason why that should be and then proved it with code.

Then I proved the unthinkable... I made the 99% fragmented index twice as slow by [insert drum roll here] defragmenting it!  That was a fortuitous accident that I can't explain.... yet.  It's not "cold fusion" either.  I've repeated the experiment in several different manners with the same results.

Why am I doing this crazy stuff?

Someday I'll tell that story but it all boils down to one thing that I learned on Monday, the 18th of January, 2016, and it's especially true in the world of computers...

The burden of proof is on the beholder.

--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.

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

• Jeff Moden wrote:

...

Then I proved the unthinkable... I made the 99% fragmented index twice as slow by [insert drum roll here] defragmenting it!  That was a fortuitous accident that I can't explain.... yet.  It's not "cold fusion" either.  I've repeated the experiment in several different manners with the same results.

....

I look forward to Microsoft's new 'Frag' function 😉

• Ooh, kind of a stinging rebuke for me today, Steve. I think I've played it safe more often than challenged myself. Ouch.

Rod

• call.copse wrote:

Jeff Moden wrote:

...

Then I proved the unthinkable... I made the 99% fragmented index twice as slow by [insert drum roll here] defragmenting it!  That was a fortuitous accident that I can't explain.... yet.  It's not "cold fusion" either.  I've repeated the experiment in several different manners with the same results.

....

I look forward to Microsoft's new 'Frag' function 😉

They've certainly forgotten who "Peter Norton" is and how his methods could be applied. 😀  I'd love to see them do it the "right way" but I'll probably be dead long before they even start on it.

--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.

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

• I agree with Rod - great challenge Steve, thank you!

Viewing 6 posts - 1 through 5 (of 5 total)