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 | emtucifor |
Most popular Wiki pages
The pages with the hacks, tips and tricks are still number one
- SQL Server Programming Hacks – 100+ List (33,646 views)
- ASP.NET Hacks (27,922 views)
- ASP.NET: Access Master Page controls from the Content Page (10,841 views)
- 5 ways to return rows from one table not in another table (9,259 views)
- ASP.NET: Add a total row to a GridView (8,159 views)
- ASP.NET: Convert HTML tables to a DataSet (7,918 views)
- ASP.NET: Insert data into SQL Server (7,893 views)
- Concatenate Values From Multiple Rows Into One Column Ordered (7,242 views)
- Row To Column (PIVOT) (6,466 views)
- ASP.NET: Strip HTML tags from a string (6,156 views)
- ASP.NET: Drawing images and bar charts with System.Drawing (6,049 views)
- ASP.NET: Read and display a text file (6,004 views)
- ASP.NET: Add paging to a repeater (5,706 views)
- Case Sensitive Search (5,700 views)
- Column To Row (UNPIVOT) (5,567 views)
Most viewed forum posts
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
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
