Phil Factor Challenge

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Contests! » Phil Factor Challenge - Part 3

Phil Factor Challenge - Part 3

Rate Topic

Display Mode

Topic Options

Author

Message

Dave Ballantyne

Posted Thursday, December 03, 2009 3:23 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 3:05 AM
Points: 1,943, Visits: 8,229

Fancy $100 ?

Give the latest Phil Factor challenge a go

http://ask.sqlservercentral.com/questions/2295/phil-factor-speed-phreak-challenge-3

Clear Sky SQL
My Blog
Kent user group

Post #828542

Steve Jones - SSC Editor

Posted Thursday, December 03, 2009 3:44 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:09 AM
Points: 31,526, Visits: 13,864

Dave,

Thanks for the challenge. Looking forward to seeing the entries.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #828554

Phil Factor

Posted Monday, December 07, 2009 7:40 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:10 AM
Points: 535, Visits: 2,295

Yes, give it a look. The original routine took 19 minutes to run. We now have entries in the 5 seconds region and each revision is pushing the speed up. It really is an eye-opener to see what you can do by slogging away with indexes, the execution plans, and imaginative thinking.
The Phone-Call Charging puzzle :Phil Factor SQL Speed Phreak Challenge #3

Best wishes,

Phil Factor
Simple Talk

Post #829849

rubysophiekatie

Posted Friday, March 22, 2013 4:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 4:34 AM
Points: 1, Visits: 1

That would be a good ideas.

Post #1434191

« Prev Topic | Next Topic »

Permissions