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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Madhi tops 33k
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kristen
Test

United Kingdom
22859 Posts

Posted - 08/09/2006 :  13:53:03  Show Profile  Reply with Quote
I'm jealous of Madhi's threads ...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47264

711 replies and 28,178 reads

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

141 replies and 33,262 reads

How the hell can exporting to Excel generate 141 replies? Surely people aren't exporting SQL data to Excel to use it as a relational database?

There are half a dozen FollowUp threads linked to Articles which have scored more reads, but probably because they are easier fodder for Search Engine Spiders

Other than those I reckon Madhi is the Top Threader!

Kristen

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 08/09/2006 :  13:59:09  Show Profile  Visit spirit1's Homepage  Reply with Quote
you wouldn't believe how much traffic exporting to excel gets...
i get around 150 views per day for this one:
http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx

and it's been up only 2 weeks. to me that seems a lot...
so yeah.. it's possible
seems export to excel is one big demand to management.




Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/09/2006 :  22:33:55  Show Profile  Reply with Quote
quote:
Originally posted by spirit1
...seems export to excel is one big demand to management...


People always seem to want their data in Excel.

I have a server that is basically dedicated to running DTS jobs to create Excel files, hundreds each day. Everything from simple data dumps to elaborate worksheets with hundreds of tabs, graphs, pivot tables, fancy formatting, etc.

My theory is that the dumbest people demand the most elaborate spreadsheets. They know they’re dumb, so they want fancy spreadsheets to make it look like they’re performing elaborate analysis. The reality is that that most have no more use for the information that they demand than a rock would.




CODO ERGO SUM
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/09/2006 :  23:02:38  Show Profile  Reply with Quote
quote:
Originally posted by Kristen

I'm jealous of Madhi's threads ...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47264

711 replies and 28,178 reads

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

141 replies and 33,262 reads

How the hell can exporting to Excel generate 141 replies? Surely people aren't exporting SQL data to Excel to use it as a relational database?

There are half a dozen FollowUp threads linked to Articles which have scored more reads, but probably because they are easier fodder for Search Engine Spiders

Other than those I reckon Madhi is the Top Threader!

Kristen


Maybe the title for Excel thread, "Export to Excel", is a really good match for the way people search on google. I did a google search for "Export to Excel", and that thread came up as number 7.

I have been a little surprised at which threads that I posted in the Script Library have the most views. I have posted 18 threads there, and 5 have more than 1000 views:
UNIX Time Conversion Functions, 1175 views
Number Table Function, 2370 views
Date Table Function F_TABLE_DATE, 3000 views
Date/Time Info and Script Links, 3001 views
Start of Week Function, 9284 views

I did a google search for "Start of Week", and that thread was number 10. Maybe a name that is a good match for the way people do searches is the key to a lot of views, because how many people really need a Start of Week Function?






CODO ERGO SUM
Go to Top of Page

PSamsig
Constraint Violating Yak Guru

Denmark
384 Posts

Posted - 08/10/2006 :  00:59:46  Show Profile  Send PSamsig a Yahoo! Message  Reply with Quote
Put 'start of week SQL' and you are number one and so are Madhi with 'export excel sql', so SQL makes (again) all the difference

-- The Heisenberg uncertainty principle also applies when debugging
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22864 Posts

Posted - 08/10/2006 :  12:08:19  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
Kristen, your FAQ and Kristen's List threads are chasing my threads

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/10/2006 :  12:22:32  Show Profile  Visit nr's Homepage  Reply with Quote
Just discovered that a lot of the reporting at one of my companies is going to migrate from business objects to excel.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11752 Posts

Posted - 08/10/2006 :  12:34:41  Show Profile  Visit spirit1's Homepage  Reply with Quote
one of your companies, nigel?
How many do you own?



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17689 Posts

Posted - 08/11/2006 :  01:34:10  Show Profile  Reply with Quote
this thread get 80K reads http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6216


KH

Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 08/11/2006 :  07:12:42  Show Profile  Reply with Quote
quote:
Originally posted by khtan

this thread get 80K reads http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6216


KH





That AskSQLTeam guy really knows how to post interesting stuff.



CODO ERGO SUM
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000