The Few - SQL Server Forums

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

The Few

Author

Topic

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-01 : 03:21:47

It is amazing to realize what a large percentage of total posts on SQLTeam that a very small number of people have made.

The top 3 posters have made over 11% of all posts, the top 10 have made over 25% of all posts, and the top 20 have made over 34% of all posts.


set nocount on
declare @a table (Name varchar(30) , Posts int, Seq int identity(1,1) )

insert into @a
select Name = 'tkizer',Posts =14566	Union all
select 'robvolk',10967	Union all
select 'nr',10525	Union all
select 'Kristen',9216	Union all
select 'X002548',9023	Union all
select 'madhivanan',7983	Union all
select 'spirit1',5831	Union all
select 'jsmith8858',5229	Union all
select 'Merkin',4770	Union all
select 'derrickleggett',4148	Union all
select 'khtan',3603	Union all
select 'jen',3440	Union all
select 'SamC',3412	Union all
select 'graz',3128	Union all
select 'AjarnMark',3107	Union all
select 'rockmoose',2894	Union all
select 'Michael Valentine Jones',2799	Union all
select 'eyechart',2681	Union all
select 'Page47',2571	Union all
select 'MichaelP',2423

print 'Percentage of posts on SQLTeam'
print ''
select
	[Top 1] =
	convert(decimal(7,2),round(
	(100.*sum(case when seq <2 then Posts else 0 end))/324826. ,2)) ,
	[Top 3] =
	convert(decimal(7,2),round(
	(100.*sum(case when seq <4 then Posts else 0 end))/324826. ,2)) ,
	[Top 5] =
	convert(decimal(7,2),round(
	(100.*sum(case when seq <6 then Posts else 0 end))/324826. ,2)) ,
	[Top 10] =
	convert(decimal(7,2),round(
	(100.*sum(case when seq <11 then Posts else 0 end))/324826. ,2)) ,
	[Top 20] =
	convert(decimal(7,2),round(
	(100.*sum(case when seq <21 then Posts else 0 end))/324826. ,2))
from
	@a

Results:


Percentage of posts on SQLTeam
 
Top 1     Top 3     Top 5     Top 10    Top 20    
--------- --------- --------- --------- --------- 
4.48      11.10     16.72     25.32     34.58

CODO ERGO SUM

Kristen
Test

22859 Posts

Posted - 2006-10-01 : 03:38:44

Are you sure two decimal places is enough?

"Never in the field of SQL Serving was so much owed by so many to so few ..."

Kristen

pootle_flump

1064 Posts

Posted - 2006-10-01 : 18:01:43

You forgot to include your post to this thead in the statistics

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-02 : 06:49:26

"A few good posters"

"The few, the proud,..."

CODO ERGO SUM

pootle_flump

1064 Posts

Posted - 2006-10-02 : 08:09:24

"Never before have so many owed so much to so few."

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 08:57:45

MVJ: just before I construct my next, caustic, reply could you calculate the percentage that were ungrateful sods?

Thanks mate ...

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-02 : 08:58:03

so how did you get the full sqlteam post count?

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 09:27:42

Total of "posts" column on http://www.sqlteam.com/forums/default.asp ??

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 09:28:14

nah, you're right, he probably just Injected the query - take far too long to cut and paste that page to Excel

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-10-02 : 09:28:47

i haven't been on that page for so long that i forgot it even existed.
Blessed active topics

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-02 : 09:28:57

quote:
Originally posted by spirit1
so how did you get the full sqlteam post count?...

Click on the All Forums link, and look at the statistics at the bottom of the page.

CODO ERGO SUM

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-02 : 09:59:23

MVJ, you and Tan help Kristen to update SQLTeam statistics

Madhivanan

Failing to plan is Planning to fail

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-02 : 11:30:54

quote:
Originally posted by Kristen
...he probably just Injected the query...

No need for that. The SA password is blank, and default port is open to the Internet.

CODO ERGO SUM

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2006-10-02 : 11:47:56

and if you look at the querystring when you reply to a post, you can see the connection string

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 12:32:34

You're not still using that Snitz Web Forum front end thingie are you?

So much easier to write your replies in Q.A.

I mean ... look at Tara's post-count.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources