Today is the two 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.

Site stats

Browsers

<td>
  43.64%
</td>
<td>
  40.585%
</td>
<td>
  10.55%
</td>
<td>
  2.30%
</td>
<td>
  2.02%
</td>
Internet Explorer
Firefox
Chrome
Safari
Opera

As you can see Internet Explorer is the number one browser, last year it was FireFox. Chrome is still number 3 but it doubled its share. FireFox is the big loser, I wrote about that already here: Has FireFox lost its Mojo, are FireFox user jumping ship to Chrome?

Countries

<td>
  Percentage
</td>
<td>
  44.83%
</td>
<td>
  9.22%
</td>
<td>
  8.07%
</td>
<td>
  4.09%
</td>
<td>
  2.68%
</td>
<td>
  2.44%
</td>
<td>
  1.73%
</td>
<td>
  1.63%
</td>
<td>
  1.29%
</td>
<td>
  1.27%
</td>
<td>
  1.24%
</td>
<td>
  1.16%
</td>
<td>
  0.98%
</td>
<td>
  0.90%
</td>
<td>
  0.81%
</td>
Country
United States
India
United Kingdom
Canada
Australia
Germany
Netherlands
Belgium
France
Italy
Brazil
Sweden
Poland
Spain
Portugal

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

Operating Systems

<td>
  93.37%
</td>
<td>
  3.21%
</td>
<td>
  2.61%
</td>
<td>
  0.47%
</td>
<td>
  0.12%
</td>
<td>
  0.08%
</td>
<td>
  0.05%
</td>
<td>
  0.02%
</td>
<td>
  0.02%
</td>
<td>
  0.02%
</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>
<td>
  0.00%
</td>
<td>
  0.00%
</td>
Windows
Macintosh
Linux
iPhone
(not set)
Android
iPod
BlackBerry
iPad
FreeBSD
SymbianOS
SunOS
Playstation 3
Playstation Portable
PalmOS
Danger Hiptop
OpenBSD
Samsung
UNIX
Nintendo Wii
NetBSD
Nokia
Sony

Windows has 93% of the market followed by the Mac and Linux, the iPhone is in number 4. It will be interesting to see where Android will be in a year.

Content

Most viewed blog posts

I love it that the math post got 44 comments, that was pretty interesting

<th>
  Views
</th>

<th>
  Posttitle
</th>

<th>
  Number of Comments
</th>

<th>
  Blogger
</th>
<td>
  40130
</td>

<td>
  <a href="/index.php?p=760">Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don't, it doesn't perform</a>
</td>

<td>
  20
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  23629
</td>

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

<td>
  30
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  18153
</td>

<td>
  <a href="/index.php?p=709">How To Enable GodMode On Windows 7</a>
</td>

<td>
  18
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  16531
</td>

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

<td>
  18
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  14648
</td>

<td>
  <a href="/index.php?p=334">SQL Server Zipcode Latitude/Longitude proximity distance search</a>
</td>

<td>
  25
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=10'>George Mastros</a>
</td>
<td>
  14133
</td>

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

<td>
  3
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  13013
</td>

<td>
  <a href="/index.php?p=593">6 ways to import data into SQL Server</a>
</td>

<td>
  18
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=68'> onpnt</a>
</td>
<td>
  11575
</td>

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

<td>
  7
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=10'>George Mastros</a>
</td>
<td>
  10026
</td>

<td>
  <a href="/index.php?p=155">ISO Week In SQL Server</a>
</td>

<td>
  10
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  9528
</td>

<td>
  <a href="/index.php?p=616">Do we need to know basic math as programmers?</a>
</td>

<td>
  44
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
</td>
<td>
  9295
</td>

<td>
  <a href="/index.php?p=456">Multi-Value Parameters in SSRS</a>
</td>

<td>
</td>

<td>
  <a href='/index.php/All/?disp=authdir&author=71'> emtucifor</a>
</td>
Rank
1
2
3
4
5
6
7
8
9
10
11

Most popular Wiki pages

The pages with the hacks, tips and tricks are still number one

  1. SQL Server Programming Hacks – 100+ List (33,646 views)
  2. ASP.NET Hacks (27,922 views)
  3. ASP.NET: Access Master Page controls from the Content Page (10,841 views)
  4. 5 ways to return rows from one table not in another table (9,259 views)
  5. ASP.NET: Add a total row to a GridView (8,159 views)
  6. ASP.NET: Convert HTML tables to a DataSet (7,918 views)
  7. ASP.NET: Insert data into SQL Server (7,893 views)
  8. Concatenate Values From Multiple Rows Into One Column Ordered (7,242 views)
  9. Row To Column (PIVOT) (6,466 views)
  10. ASP.NET: Strip HTML tags from a string (6,156 views)
  11. ASP.NET: Drawing images and bar charts with System.Drawing (6,049 views)
  12. ASP.NET: Read and display a text file (6,004 views)
  13. ASP.NET: Add paging to a repeater (5,706 views)
  14. Case Sensitive Search (5,700 views)
  15. Column To Row (UNPIVOT) (5,567 views)

Most viewed forum posts

<th>
  Views
</th>
<td>
  30203
</td>
<td>
  5333
</td>
<td>
  3324
</td>
<td>
  2597
</td>
<td>
  2427
</td>
<td>
  2319
</td>
<td>
  2270
</td>
<td>
  2133
</td>
<td>
  2010
</td>
<td>
  1991
</td>
<td>
  1905
</td>
<td>
  1840
</td>
<td>
  1825
</td>
<td>
  1755
</td>
<td>
  1712
</td>
<td>
  1592
</td>
<td>
  1545
</td>
<td>
  1511
</td>
<td>
  1470
</td>
Topic
SQL Server Programming Hacks
LTD Puzzle 1: Friday the Thirteenths
LTD Puzzle 6: split a filepath
LTD Puzzle 14: FInd the match
Do you prefix table names
LTD Puzzle 9: Find it
Amazing surf shots
Fantasy Football 2008
Need help deciding SQL Version
LTD Puzzle 2: Regular Pentagon
LTD Puzzle 11: Hello World! For Hackers
LTD Puzzle 5: Calculating the Fibonacci Sequence
LTD Puzzle 4: Finding Prime Numbers
Classic ASP URL Rewriting – A Practical Example
LTD Puzzle 3: ASCII Art Shapes
Website Attacks
Puzzle 23 – Distance to line segment
jQuery vs. ExtJS
Building Scalable Websites

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

If you are interested in the stats for our first year then visit this link: Less Than Dot A Year In Review