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

Internet Explorer 43.64%
Firefox 40.585%
Chrome 10.55%
Safari 2.30%
Opera 2.02%

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

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

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

Operating Systems

Windows 93.37%
Macintosh 3.21%
Linux 2.61%
iPhone 0.47%
(not set) 0.12%
Android 0.08%
iPod 0.05%
BlackBerry 0.02%
iPad 0.02%
FreeBSD 0.02%
SymbianOS 0.01%
SunOS 0.01%
Playstation 3 0.00%
Playstation Portable 0.00%
PalmOS 0.00%
Danger Hiptop 0.00%
OpenBSD 0.00%
Samsung 0.00%
UNIX 0.00%
Nintendo Wii 0.00%
NetBSD 0.00%
Nokia 0.00%
Sony 0.00%

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

Rank Views Posttitle Number of Comments Blogger
1 40130 Do you use Column=@Param OR @Param IS NULL in your WHERE clause? Don’t, it doesn’t perform 20 SQLDenis
2 23629 The Ten Most Asked SQL Server Questions And Their Answers 30 SQLDenis
3 18153 How To Enable GodMode On Windows 7 18 SQLDenis
4 16531 Good SQL Articles To Read If You Can’t Afford Books 18 SQLDenis
5 14648 SQL Server Zipcode Latitude/Longitude proximity distance search 25 George Mastros
6 14133 Collection Of Puzzles For Programmers 3 SQLDenis
7 13013 6 ways to import data into SQL Server 18 onpnt
8 11575 Calculating Mean, Median and Mode with SQL Server 7 George Mastros
9 10026 ISO Week In SQL Server 10 SQLDenis
10 9528 Do we need to know basic math as programmers? 44 SQLDenis
11 9295 Multi-Value Parameters in SSRS 0 emtucifor

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

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

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