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

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.