Today is the one year anniversary of Less Than Dot, I cannot believe this, 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.

First the site stats.

Browsers

<td>
  53.05%
</td>
<td>
  35.14%
</td>
<td>
  5.12%
</td>
<td>
  3.22%
</td>
<td>
  2.55%
</td>
Firefox
Internet Explorer
Chrome
Safari
Opera

As you can see FireFox is the number one browser, this is of course expected with a technical site. It is also interesting to see that Chrome is the number 3 browser already.

Countries

<td>
  50.56%
</td>
<td>
  7.59%
</td>
<td>
  5.53%
</td>
<td>
  5.33%
</td>
<td>
  2.24%
</td>
<td>
  1.95%
</td>
<td>
  1.91%
</td>
<td>
  1.65%
</td>
<td>
  1.31%
</td>
<td>
  1.07%
</td>
United States
United Kingdom
India
Canada
Australia
Netherlands
Germany
Belgium
Poland
Ireland

Here is where the users are coming from, these are the top 10 countries

Operating Systems

<td>
  87.99%
</td>
<td>
  7.26%
</td>
<td>
  4.17%
</td>
<td>
  0.30%
</td>
<td>
  0.15%
</td>
<td>
  0.05%
</td>
<td>
  0.01%
</td>
<td>
  0.01%
</td>
<td>
  0.01%
</td>
<td>
  0.01%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
<td>
  > 0.00%
</td>
Windows
Macintosh
Linux
iPhone
(not set)
iPod
SunOS
Android
FreeBSD
SymbianOS
Danger Hiptop
Playstation 3
OpenBSD
Nintendo Wii
PalmOS
NetBSD
UNIX
BeOS
HPUX

Windows has almost 88% of the market followed by the Mac and Linux, the iPhone is in number 4

Now we go on to the content on this site.

Most popular blogposts

<th>
  Views
</th>

<th>
  Post title
</th>
<td>
  11718
</td>

<td>
  <a href="/index.php?p=27">Good SQL Articles To Read If You Can't Afford Books</a>
</td>
<td>
  10606
</td>

<td>
  <a href="/index.php?p=249">The Ten Most Asked SQL Server Questions And Their Answers</a>
</td>
<td>
  10081
</td>

<td>
  <a href="/index.php?p=348">Collection Of Puzzles For Programmers</a>
</td>
<td>
  6774
</td>

<td>
  <a href="/index.php?p=114">Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code</a>
</td>
<td>
  4050
</td>

<td>
  <a href="/index.php?p=266">Calculating Mean, Median and Mode with SQL Server</a>
</td>
<td>
  4044
</td>

<td>
  <a href="/index.php?p=58">Printing to a zebra printer from VB.Net</a>
</td>
<td>
  3910
</td>

<td>
  <a href="/index.php?p=157">SQL Server 2008 Cumulative Update 1 is available from Microsoft</a>
</td>
<td>
  3874
</td>

<td>
  <a href="/index.php?p=256">SQL Server Rounding Methods</a>
</td>
<td>
  3842
</td>

<td>
  <a href="/index.php?p=94">5 Books Every Developer Should Read</a>
</td>
<td>
  3801
</td>

<td>
  <a href="/index.php?p=259">Extracting numbers with SQL Server</a>
</td>
Rank
1
2
3
4
5
6
7
8
9
10

Most popular Wiki pages

  1. SQL Server Programming Hacks – 100+ List (19,784 views)
  2. ASP.NET Hacks (19,405 views)
  3. Main Page (18,391 views)
  4. ASP.NET: Access Master Page controls from the Content Page (6,170 views)
  5. 5 ways to return rows from one table not in another table (5,757 views)
  6. ASP.NET: Add a total row to a GridView (4,804 views)
  7. ASP.NET: Convert HTML tables to a DataSet (4,548 views)
  8. ASP.NET: Insert data into SQL Server (4,243 views)
  9. Concatenate Values From Multiple Rows Into One Column Ordered (4,150 views)
  10. Case Sensitive Search (3,508 views)

Most popular forum posts

<th>
  Views
</th>
<td>
  27057
</td>
<td>
  3438
</td>
<td>
  2092
</td>
<td>
  1759
</td>
<td>
  1560
</td>
<td>
  1514
</td>
<td>
  1277
</td>
<td>
  1242
</td>
<td>
  1222
</td>
<td>
  1219
</td>
Topic
SQL Server Programming Hacks
LTD Puzzle 1: Friday the Thirteenths
LTD Puzzle 6: split a filepath
LTD Puzzle 14: FInd the match
LTD Puzzle 9: Find it
Do you prefix table names
LTD Puzzle 5: Calculating the Fibonacci Sequence
LTD Puzzle 11: Hello World! For Hackers
Need help deciding SQL Version
LTD Puzzle 2: Regular Pentagon

That is it, thank you for visiting and we will have lots of more content coming up in the year ahead. If you have any questions don’t hesitate to ask in our forums