Today is the third year anniversary of Less Than Dot, time is flying by so fast. I would like to list some stats about the site and also list the most popular blogposts, wiki pages and forum posts.

Operating Systems

Operating System Percentage
Windows 90.51%
Macintosh 4.07%
Linux 3.20%
iPhone 0.88%
Android 0.58%
iPad 0.41%
(not set) 0.18%
iPod 0.07%
BlackBerry 0.05%
FreeBSD 0.01%
SymbianOS 0.01%
SunOS 0.01%
UNIX 0.00%
OpenBSD 0.00%
Playstation 3 0.00%
Nokia 0.00%
Samsung 0.00%
Sony 0.00%
NetBSD 0.00%
Nintendo Wii 0.00%
PalmOS 0.00%
Google TV 0.00%
Playstation Portable 0.00%

As you can see Windows is still number 1 but is is almost below 90% now. The Macintosh is at 4%. We have to see if mobile really will explode and take up 30% or so in the coming 2 to three years. The 0.00% are shown because it is rounded to 2 decimal places

Browsers

Browser Percentage
Internet Explorer 37.16%
Firefox 34.85%
Chrome 22.21%
Safari 3.00%
Opera 1.73%
Mozilla Compatible Agent 0.52%
Mozilla 0.16%
IE with Chrome Frame 0.11%
Opera Mini 0.06%
Konqueror 0.05%
SeaMonkey 0.03%
RockMelt 0.02%
Android Browser 0.01%
BlackBerry9000 0.01%
BlackBerry9700 0.01%
BlackBerry9530 0.01%
Camino 0.01%
BlackBerry9630 0.01%
Lunascape 0.00%

Nothing new in the browser space except for the fact that Chrome is growing really fast

Countries

Country/Territory Percentage
United States 41.40%
United Kingdom 8.42%
India 8.25%
Canada 4.16%
Australia 2.74%
Germany 2.54%
Netherlands 1.63%
France 1.50%
Belgium 1.44%
Brazil 1.37%
Italy 1.22%
Sweden 1.15%
South Africa 0.99%
Poland 0.94%
Spain 0.93%
Russia 0.90%
Israel 0.74%
Mexico 0.69%
Turkey 0.68%
New Zealand 0.65%

Nothing new here either, as expected for an English language site, the US is number one.

Search terms

Search term Percentage
stand up desk 0.88%
string or binary data would be truncated 0.38%
string or binary data would be truncated. 0.36%
sqlcop 0.23%
operand type clash: int is incompatible with date 0.22%
operand type clash: date is incompatible with int 0.20%
http://lessthandot.com 0.19%
sql mean 0.16%
itextsharp headerfooter 0.16%
model view presenter 0.15%
less than dot 0.14%
puzzles for programmers 0.13%
ssis delayvalidation 0.11%
standing desk 0.11%
sql cop 0.11%
stand-up desk 0.10%
stand up desks 0.09%
tortoisegit 0.09%
sp_executesql 0.09%
export html table to excel 0.08%

Those are the top search terms that users clicked on to get to this site.

Mobile

Operating System Percentage
iPhone 43.62%
Android 28.77%
iPad 20.54%
iPod 3.49%
BlackBerry 2.57%
SymbianOS 0.62%
Windows 0.24%
Nokia 0.06%
Samsung 0.04%
Sony 0.04%
PalmOS 0.01%

The massive lead the iPhone had last year is eroding, by next year Android will be number one.(it already is for the last couple of months)

Most viewed blog posts

Rank Views Posttitle Number of Comments Blogger
1 41661 Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform 22 SQLDenis
2 34692 The Ten Most Asked SQL Server Questions And Their Answers 41 SQLDenis
3 32892 Should I abandon VB.Net? 127 Christiaan Baes (chrissie1)
4 26053 Collection Of Puzzles For Programmers 2 SQLDenis
5 25693 How To Enable GodMode On Windows 7 20 SQLDenis
6 25224 Export HTML table to Excel with grid lines 12 kaht
7 24586 SQL Server Zipcode Latitude/Longitude proximity distance search 39 George Mastros (gmmastros)
8 21854 6 ways to import data into SQL Server 19 Ted Krueger (onpnt)
9 21774 Calculating Mean, Median and Mode with SQL Server 12 George Mastros (gmmastros)
10 20094 Good SQL Articles To Read If You Can't Afford Books 18 SQLDenis
11 17499 Multi-Value Parameters in SSRS emtucifor
12 17318 SQL Server 2008 Proximity Search With The Geography Data Type 31 SQLDenis
13 16778 ISO Week In SQL Server 11 SQLDenis
14 16634 How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005 10 SQLDenis
15 16522 Why (and How) I Model 2 Eli Weinstock-Herman (tarwn)

Those are the most popular blog posts on the site.

The pages with the hacks, tips and tricks are still number two behind the main wiki page.

  1. Main Page (557,488 views)
  2. SQL Server Programming Hacks – 100+ List (44,500 views)
  3. ASP.NET Hacks (33,312 views)
  4. ASP.NET: Access Master Page controls from the Content Page (14,358 views)
  5. 5 ways to return rows from one table not in another table (13,906 views)
  6. Kill All Active Connections To A Database (11,919 views)
  7. Row To Column (PIVOT) (10,816 views)
  8. ASP.NET: Convert HTML tables to a DataSet (10,680 views)
  9. ASP.NET: Add a total row to a GridView (10,484 views)
  10. Concatenate Values From Multiple Rows Into One Column Ordered (10,366 views)
  11. ASP.NET: Insert data into SQL Server (10,170 views)
  12. Use the sys.dm db index usage stats dmv to check if indexes are being used (9,038 views)
  13. ASP.NET: Strip HTML tags from a string (8,865 views)
  14. Column To Row (UNPIVOT) (8,664 views)
  15. SQL Server Admin Hacks (8,489 views)

That’s it in terms of stats, we will bring you more content this year and it will be interesting how the stats will shift into mobile in the next couple of years.