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

  <th>
    Percentage
  </th>
</tr>

<tr>
  <td>
    Windows
  </td>
  
  <td>
    90.51%
  </td>
</tr>

<tr>
  <td>
    Macintosh
  </td>
  
  <td>
    4.07%
  </td>
</tr>

<tr>
  <td>
    Linux
  </td>
  
  <td>
    3.20%
  </td>
</tr>

<tr>
  <td>
    iPhone
  </td>
  
  <td>
    0.88%
  </td>
</tr>

<tr>
  <td>
    Android
  </td>
  
  <td>
    0.58%
  </td>
</tr>

<tr>
  <td>
    iPad
  </td>
  
  <td>
    0.41%
  </td>
</tr>

<tr>
  <td>
    (not set)
  </td>
  
  <td>
    0.18%
  </td>
</tr>

<tr>
  <td>
    iPod
  </td>
  
  <td>
    0.07%
  </td>
</tr>

<tr>
  <td>
    BlackBerry
  </td>
  
  <td>
    0.05%
  </td>
</tr>

<tr>
  <td>
    FreeBSD
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    SymbianOS
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    SunOS
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    UNIX
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    OpenBSD
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Playstation 3
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Nokia
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Samsung
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Sony
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    NetBSD
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Nintendo Wii
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    PalmOS
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Google TV
  </td>
  
  <td>
    0.00%
  </td>
</tr>

<tr>
  <td>
    Playstation Portable
  </td>
  
  <td>
    0.00%
  </td>
</tr>
Operating System

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

  <th>
    Percentage
  </th>
</tr>

<tr>
  <td>
    Internet Explorer
  </td>
  
  <td>
    37.16%
  </td>
</tr>

<tr>
  <td>
    Firefox
  </td>
  
  <td>
    34.85%
  </td>
</tr>

<tr>
  <td>
    Chrome
  </td>
  
  <td>
    22.21%
  </td>
</tr>

<tr>
  <td>
    Safari
  </td>
  
  <td>
    3.00%
  </td>
</tr>

<tr>
  <td>
    Opera
  </td>
  
  <td>
    1.73%
  </td>
</tr>

<tr>
  <td>
    Mozilla Compatible Agent
  </td>
  
  <td>
    0.52%
  </td>
</tr>

<tr>
  <td>
    Mozilla
  </td>
  
  <td>
    0.16%
  </td>
</tr>

<tr>
  <td>
    IE with Chrome Frame
  </td>
  
  <td>
    0.11%
  </td>
</tr>

<tr>
  <td>
    Opera Mini
  </td>
  
  <td>
    0.06%
  </td>
</tr>

<tr>
  <td>
    Konqueror
  </td>
  
  <td>
    0.05%
  </td>
</tr>

<tr>
  <td>
    SeaMonkey
  </td>
  
  <td>
    0.03%
  </td>
</tr>

<tr>
  <td>
    RockMelt
  </td>
  
  <td>
    0.02%
  </td>
</tr>

<tr>
  <td>
    Android Browser
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    BlackBerry9000
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    BlackBerry9700
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    BlackBerry9530
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    Camino
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    BlackBerry9630
  </td>
  
  <td>
    0.01%
  </td>
</tr>

<tr>
  <td>
    Lunascape
  </td>
  
  <td>
    0.00%
  </td>
</tr>
Browser

Nothing new in the browser space except for the fact that Chrome is growing really fast

Countries

  <th>
    Percentage
  </th>
</tr>

<tr>
  <td>
    United States
  </td>
  
  <td>
    41.40%
  </td>
</tr>

<tr>
  <td>
    United Kingdom
  </td>
  
  <td>
    8.42%
  </td>
</tr>

<tr>
  <td>
    India
  </td>
  
  <td>
    8.25%
  </td>
</tr>

<tr>
  <td>
    Canada
  </td>
  
  <td>
    4.16%
  </td>
</tr>

<tr>
  <td>
    Australia
  </td>
  
  <td>
    2.74%
  </td>
</tr>

<tr>
  <td>
    Germany
  </td>
  
  <td>
    2.54%
  </td>
</tr>

<tr>
  <td>
    Netherlands
  </td>
  
  <td>
    1.63%
  </td>
</tr>

<tr>
  <td>
    France
  </td>
  
  <td>
    1.50%
  </td>
</tr>

<tr>
  <td>
    Belgium
  </td>
  
  <td>
    1.44%
  </td>
</tr>

<tr>
  <td>
    Brazil
  </td>
  
  <td>
    1.37%
  </td>
</tr>

<tr>
  <td>
    Italy
  </td>
  
  <td>
    1.22%
  </td>
</tr>

<tr>
  <td>
    Sweden
  </td>
  
  <td>
    1.15%
  </td>
</tr>

<tr>
  <td>
    South Africa
  </td>
  
  <td>
    0.99%
  </td>
</tr>

<tr>
  <td>
    Poland
  </td>
  
  <td>
    0.94%
  </td>
</tr>

<tr>
  <td>
    Spain
  </td>
  
  <td>
    0.93%
  </td>
</tr>

<tr>
  <td>
    Russia
  </td>
  
  <td>
    0.90%
  </td>
</tr>

<tr>
  <td>
    Israel
  </td>
  
  <td>
    0.74%
  </td>
</tr>

<tr>
  <td>
    Mexico
  </td>
  
  <td>
    0.69%
  </td>
</tr>

<tr>
  <td>
    Turkey
  </td>
  
  <td>
    0.68%
  </td>
</tr>

<tr>
  <td>
    New Zealand
  </td>
  
  <td>
    0.65%
  </td>
</tr>
Country/Territory

Nothing new here either, as expected for an English language site, the US is number one.

Search terms

  <th>
    Percentage
  </th>
</tr>

<tr>
  <td>
    stand up desk
  </td>
  
  <td>
    0.88%
  </td>
</tr>

<tr>
  <td>
    string or binary data would be truncated
  </td>
  
  <td>
    0.38%
  </td>
</tr>

<tr>
  <td>
    string or binary data would be truncated.
  </td>
  
  <td>
    0.36%
  </td>
</tr>

<tr>
  <td>
    sqlcop
  </td>
  
  <td>
    0.23%
  </td>
</tr>

<tr>
  <td>
    operand type clash: int is incompatible with date
  </td>
  
  <td>
    0.22%
  </td>
</tr>

<tr>
  <td>
    operand type clash: date is incompatible with int
  </td>
  
  <td>
    0.20%
  </td>
</tr>

<tr>
  <td>
    http://lessthandot.com
  </td>
  
  <td>
    0.19%
  </td>
</tr>

<tr>
  <td>
    sql mean
  </td>
  
  <td>
    0.16%
  </td>
</tr>

<tr>
  <td>
    itextsharp headerfooter
  </td>
  
  <td>
    0.16%
  </td>
</tr>

<tr>
  <td>
    model view presenter
  </td>
  
  <td>
    0.15%
  </td>
</tr>

<tr>
  <td>
    less than dot
  </td>
  
  <td>
    0.14%
  </td>
</tr>

<tr>
  <td>
    puzzles for programmers
  </td>
  
  <td>
    0.13%
  </td>
</tr>

<tr>
  <td>
    ssis delayvalidation
  </td>
  
  <td>
    0.11%
  </td>
</tr>

<tr>
  <td>
    standing desk
  </td>
  
  <td>
    0.11%
  </td>
</tr>

<tr>
  <td>
    sql cop
  </td>
  
  <td>
    0.11%
  </td>
</tr>

<tr>
  <td>
    stand-up desk
  </td>
  
  <td>
    0.10%
  </td>
</tr>

<tr>
  <td>
    stand up desks
  </td>
  
  <td>
    0.09%
  </td>
</tr>

<tr>
  <td>
    tortoisegit
  </td>
  
  <td>
    0.09%
  </td>
</tr>

<tr>
  <td>
    sp_executesql
  </td>
  
  <td>
    0.09%
  </td>
</tr>

<tr>
  <td>
    export html table to excel
  </td>
  
  <td>
    0.08%
  </td>
</tr>
Search term

Those are the top search terms that users clicked on to get to this site.

Mobile

  <th>
    Percentage
  </th>
</tr>

<tr>
  <td>
    iPhone
  </td>
  
  <td>
    43.62%
  </td>
</tr>

<tr>
  <td>
    Android
  </td>
  
  <td>
    28.77%
  </td>
</tr>

<tr>
  <td>
    iPad
  </td>
  
  <td>
    20.54%
  </td>
</tr>

<tr>
  <td>
    iPod
  </td>
  
  <td>
    3.49%
  </td>
</tr>

<tr>
  <td>
    BlackBerry
  </td>
  
  <td>
    2.57%
  </td>
</tr>

<tr>
  <td>
    SymbianOS
  </td>
  
  <td>
    0.62%
  </td>
</tr>

<tr>
  <td>
    Windows
  </td>
  
  <td>
    0.24%
  </td>
</tr>

<tr>
  <td>
    Nokia
  </td>
  
  <td>
    0.06%
  </td>
</tr>

<tr>
  <td>
    Samsung
  </td>
  
  <td>
    0.04%
  </td>
</tr>

<tr>
  <td>
    Sony
  </td>
  
  <td>
    0.04%
  </td>
</tr>

<tr>
  <td>
    PalmOS
  </td>
  
  <td>
    0.01%
  </td>
</tr>
Operating System

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

  <th>
    Views
  </th>
  
  <th>
    Posttitle
  </th>
  
  <th>
    Number of Comments
  </th>
  
  <th>
    Blogger
  </th>
</tr>

<tr>
  <td>
    1
  </td>
  
  <td>
    41661
  </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>
    22
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    2
  </td>
  
  <td>
    34692
  </td>
  
  <td>
    <a href="/index.php?p=249">The Ten Most Asked SQL Server Questions And Their Answers</a>
  </td>
  
  <td>
    41
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    3
  </td>
  
  <td>
    32892
  </td>
  
  <td>
    <a href="/index.php?p=1136">Should I abandon VB.Net?</a>
  </td>
  
  <td>
    127
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=7'>Christiaan Baes (chrissie1)</a>
  </td>
</tr>

<tr>
  <td>
    4
  </td>
  
  <td>
    26053
  </td>
  
  <td>
    <a href="/index.php?p=348">Collection Of Puzzles For Programmers</a>
  </td>
  
  <td>
    2
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    5
  </td>
  
  <td>
    25693
  </td>
  
  <td>
    <a href="/index.php?p=709">How To Enable GodMode On Windows 7</a>
  </td>
  
  <td>
    20
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    6
  </td>
  
  <td>
    25224
  </td>
  
  <td>
    <a href="/index.php?p=499">Export HTML table to Excel with grid lines</a>
  </td>
  
  <td>
    12
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=48'> kaht</a>
  </td>
</tr>

<tr>
  <td>
    7
  </td>
  
  <td>
    24586
  </td>
  
  <td>
    <a href="/index.php?p=334">SQL Server Zipcode Latitude/Longitude proximity distance search</a>
  </td>
  
  <td>
    39
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=10'>George Mastros (gmmastros)</a>
  </td>
</tr>

<tr>
  <td>
    8
  </td>
  
  <td>
    21854
  </td>
  
  <td>
    <a href="/index.php?p=593">6 ways to import data into SQL Server</a>
  </td>
  
  <td>
    19
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=68'>Ted Krueger (onpnt)</a>
  </td>
</tr>

<tr>
  <td>
    9
  </td>
  
  <td>
    21774
  </td>
  
  <td>
    <a href="/index.php?p=266">Calculating Mean, Median and Mode with SQL Server</a>
  </td>
  
  <td>
    12
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=10'>George Mastros (gmmastros)</a>
  </td>
</tr>

<tr>
  <td>
    10
  </td>
  
  <td>
    20094
  </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>
</tr>

<tr>
  <td>
    11
  </td>
  
  <td>
    17499
  </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>
</tr>

<tr>
  <td>
    12
  </td>
  
  <td>
    17318
  </td>
  
  <td>
    <a href="/index.php?p=335">SQL Server 2008 Proximity Search With The Geography Data Type</a>
  </td>
  
  <td>
    31
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    13
  </td>
  
  <td>
    16778
  </td>
  
  <td>
    <a href="/index.php?p=155">ISO Week In SQL Server</a>
  </td>
  
  <td>
    11
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    14
  </td>
  
  <td>
    16634
  </td>
  
  <td>
    <a href="/index.php?p=318">How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005</a>
  </td>
  
  <td>
    10
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=4'> SQLDenis</a>
  </td>
</tr>

<tr>
  <td>
    15
  </td>
  
  <td>
    16522
  </td>
  
  <td>
    <a href="/index.php?p=986">Why (and How) I Model</a>
  </td>
  
  <td>
    2
  </td>
  
  <td>
    <a href='/index.php/All/?disp=authdir&author=9'>Eli Weinstock-Herman (tarwn)</a>
  </td>
</tr>
Rank

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.