Another year is about to end, time to do another post with some stats and numbers

The 10 most read posts of the year

We had a lot of blog posts in 2011, I blogged 105 times the last year. Here is a list of the ten most read posts for the year 2011

  1. Should I abandon VB.Net?
  2. Calculating Mean, Median and Mode with SQL Server
  3. The Ten Most Asked SQL Server Questions And Their Answers
  4. You need to have hardware virtualization enabled if you want to run Windows 8 in Virtual Box
  5. 6 ways to import data into SQL Server
  6. SQL Server Zipcode Latitude/Longitude proximity distance search
  7. How to enable xp_cmdshell and Ad Hoc Distributed Queries on SQL Server 2005
  8. VB.Net isn’t C#
  9. Trying the Stand-Up Desk
  10. Suppress string or binary data would be truncated messages with the ANSI WARNINGS setting

Mobile stats

Mobile device will surpass desktop and laptops in the next year or two. Here is what the percentages looked like from visits to Lessthandot.

Month  Iphone  Android iPad    WinPhone    Blackberry
----    ------  ------- ------  --------        -----------
Jan 42.46   28.1    22.93   0.4         1.61
Feb 39.38   33.44   21.46   0.3         2.29
Mar 39.28   31.67   22.7    0.3         1.77
Apr 36.31   36.87   22.72   0.2         0.93
May 33.36   33.62   28.3    0.2         2.14
Jun 33.21   33.43   28.12   0.3         1.29
Jul 34.48   31.03   30.19   0.2         0.8
Aug 32.67   34.42   29.41   0.2         0.81
Sep 32.06   35.24   29.03   0.2         0.64
Oct 32.03   36.45   29.38   0.1         0.31
Nov 27.83   36.71   31.16   1.41            0.4
Dec 27.98   34.38   27.81   4.09            2.87

And here it is as a chart

Mobile2011

Android is the clear winner here, but iOS is still bigger if you add iPhone and iPad together. You can also see that the Nokia launch of the windows phone has some success because windows phone shot up to 4% from less than 0.5% for most of the year

Search Keywords

Here is what people searched for most when they visited our site from a search engine

Percentage Search term
1.09% string or binary data would be truncated
1.05% string or binary data would be truncated.
0.87% stand up desk
0.42% operand type clash: int is incompatible with date
0.36% sql mean
0.36% operand type clash: date is incompatible with int
0.33% ssis interview questions
0.25% sqlcop
0.22% http://lessthandot.com
0.21% cannot resolve collation conflict for equal to operation
0.20% cannot resolve collation conflict for equal to operation.
0.17% model view presenter
0.17% ssis delayvalidation
0.15% less than dot
0.14% sql server denali management studio
0.13% puzzles for programmers
0.13% itextsharp headerfooter
0.13% bi interview questions
0.13% sql denali
0.12% sp_executesql
0.12% html table to excel
0.12% lessthandot
0.12% parallel.foreach
0.12% business intelligence interview questions
0.11% export html table to excel
0.11% mongodb bulk insert
0.11% operand type clash int is incompatible with date
0.11% msforeachdb
0.11% ole db provider 'microsoft.jet.oledb.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
0.10% sp_change_users_login
0.10% sybase iq
0.10% ssis delay validation
0.10% how to change datatype of a column in sql server 2008
0.09% msforeachtable
0.09% nested page .php in master page
0.09% ssrs dynamic columns
0.09% tortoisegit
0.09% itextsharp footer
0.09% msg 15281, level 16, state 1, procedure xp_cmdshell, line 1
0.09% denali sql
0.09% conceptual data model
0.08% sp execute sql
0.08% sql server mean
0.08% sql server mode
0.08% ole db provider 'microsoft.ace.oledb.12.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
0.08% date is incompatible with int
0.08% sql server memory leak
0.08% stand-up desk
0.08% rid lookup

That’s all for this post, see you next year