Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

Peso 18k

Author

Topic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-13 : 04:41:11

CONGRATS PETER!!!

May your beer never stop flowing!

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-08-13 : 05:49:34

Thanks for all your exceedingly wise counsel!

Congratulations.

-------------
Charlie

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-13 : 05:56:07

Hi!
Sorry I'm late for the party

I was occupied with this topic
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108660

Thank you both.

E 12°55'05.25"
N 56°04'39.16"

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-08-13 : 07:31:13

CONGRATS brainiac

Webfred

Too Old to Rock 'n' Roll, Too Young to Die

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-08-13 : 08:35:01

Only 18K? You can do much better than that. Back to work, get busy postin' !!!

- "congrats!"

- Jeff
http://weblogs.sqlteam.com/JeffS

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-13 : 08:56:24

Congratulation Peter !

[spoiler]-----[/spoiler]

[spoiler]----[/spoiler]

[spoiler]-----[/spoiler]

[spoiler]----[/spoiler]

[spoiler]-----[/spoiler]

KH
[spoiler]Time is always against us[/spoiler]

DavidChel
Constraint Violating Yak Guru

474 Posts

Posted - 2008-08-13 : 09:02:57

That's simply amazing.

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-13 : 09:15:21

so when will Peter overtake Tara ....?

by my reckoning it should be about May next year (based on current post rates), anyone care for a wager?

Em

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2008-08-13 : 09:21:30

Congratulations

"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-13 : 09:23:54

You cheat!

SELECT TOP 1	DATEADD(DAY, Number, GETDATE())
FROM		master..spt_values
WHERE		Type = 'p'
		AND 18053 + 21.91 * Number > 21385 + 10.02 * Number
ORDER BY	Number

E 12°55'05.25"
N 56°04'39.16"

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-08-13 : 09:28:00

er... it was a pure guess, honest

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-13 : 09:33:21

Sure!

I think you instantly calculated

SELECT TOP 1	DATEADD(DAY, Number, GETDATE())
FROM		master..spt_values
WHERE		Type = 'p'
		AND (21.91 - 10.02) * Number > 21385 - 18056
ORDER BY	Number

E 12°55'05.25"
N 56°04'39.16"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 10:15:28

Congrats Patron Saint of Lost Yaks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-13 : 10:22:50

Keep going Visakh. You will have more posts than me on 2015-04-01 16:21:29.893

E 12°55'05.25"
N 56°04'39.16"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 10:27:47

quote:
Originally posted by Peso

Keep going Visakh. You will have more posts than me on 2015-04-01 16:21:29.893

E 12°55'05.25"
N 56°04'39.16"

Thanks for encouragement Peso. I've been always motivated by your solutions

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2008-08-13 : 11:29:29

Congrats Peso..hopefully the forums is using BIGINT and not INT.. :)

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-13 : 11:30:40

Thank you!

I think I am safe. It works for Tara.

E 12°55'05.25"
N 56°04'39.16"

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-08-13 : 11:40:47

congrats! I honestly don't know how you and the other post machines do it.

elsasoft.org

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-13 : 13:06:10

quote:
Originally posted by Peso

Sure!

I think you instantly calculated
SELECT TOP 1 DATEADD(DAY, Number, GETDATE())
FROM master..spt_values
WHERE Type = 'p'
AND (21.91 - 10.02) * Number > 21385 - 18056
ORDER BY Number

E 12°55'05.25"
N 56°04'39.16"

Except you have to ignore the first few years where my post rate wasn't as high as the past couple of years. I believe my current post rate is higher than what is reflected in my profile.

Congrats Peso!

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-08-13 : 13:14:50

she ain't going down that easy

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-14 : 02:09:59

Some data for your calculation

poster  posts                                  rate
------- -------------------------------------- ------- 
Tara    21000(2008-07-22) - 21417(2008-08-13)    18.95 
Tara    20000(2008-05-29) - 21000(2008-07-22)    18.52 
Tara    19000(2008-04-10) - 20000(2008-05-29)    20.41 
Peter   17000(2008-06-21) - 18000(2008-08-13)    18.87
Peter   16000(2008-05-12) - 17000(2008-06-21)    25.00 
Peter   15000(2008-04-09) - 16000(2008-05-12)    30.30

If they continue at the current rate, it may take forever

KH
[spoiler]Time is always against us[/spoiler]

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources