Every year I like to do a couple of posts showing some analytics about the visitors to this site

In this post we will be looking at the searches, the content and the countries that visitors came from

Content

Here are the top 25 most visited pages on this site during the year 2012.

Page Title Percentage
All Blogs 15.98%
Collection Of Puzzles For Programmers 11.40%
View active topics 8.92%
Launchpad 7.90%
SqlCop 6.15%
Should I abandon VB.Net? 4.99%
Index page 4.80%
Calculating Mean, Median and Mode with SQL Server 4.62%
The Ten Most Asked SQL Server Questions And Their Answers 4.60%
Trying the Stand-Up Desk 3.09%
SQL Server Zipcode Latitude/Longitude proximity distance search 3.06%
Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax 2.79%
6 ways to import data into SQL Server 2.30%
SQL Server 2008 Proximity Search With The Geography Data Type 2.29%
How To Enable GodMode On Windows 7 2.25%
Be Mindful With Your Code 2.21%
Kill All Active Connections To A Database – Wiki 2.19%
Delete all data in database (when you have FKs) 1.81%
SQL Server Programming Hacks – 100+ List – Wiki 1.80%
View forum – Programmer Puzzles 1.76%
Working with 32 bit providers and 64 bit SQL Server 1.73%
Extracting numbers with SQL Server 1.71%
Cursors and How to Avoid Them – Wiki 1.69%

Searches

Here is a list of the most used search terms, as you can see it is mostly SQL related, this makes sense since most of the content is SQL related

sqlcop

ssis interview questions

sql mean

operand type clash: date is incompatible with int

string or binary data would be truncated

operand type clash: int is incompatible with date

cannot resolve collation conflict for equal to operation

lessthandot

wizard

programmer vs developer

sql 2008 backup compression log

sp_change_users_login

bi interview questions

sql 2000 pivot

alter column datatype in sql server 2008

cidaemon.exe server 2003

lessthandot + sqlserver

sql server geography

sql server activity monitor capture data

ssis delayvalidation

sql server mean

annot define primary key constraint on nullable column in table

mean sql

msforeachdb

code katas

Countries

Below is a list of the top 25 countries that visitors came from. Not surprisingly the United States is number 1, India is number 2. China is absent from this list, the other Asian country is the Philippines. The percentage are for the top 25 only not for the whole list.

Country / Territory Percentage
United States 36.73%
India 9.39%
United Kingdom 7.56%
Canada 3.55%
Germany 2.80%
Australia 2.63%
Belgium 1.78%
France 1.71%
Netherlands 1.70%
Brazil 1.52%
Italy 1.43%
Spain 1.39%
Poland 1.20%
Sweden 1.20%
Russia 1.15%
(not set) 1.07%
South Africa 1.01%
Mexico 0.86%
Turkey 0.84%
Philippines 0.71%
Israel 0.70%
Portugal 0.70%
New Zealand 0.66%
Denmark 0.65%
Switzerland 0.65%
Total 100.00%

Here is the breakdown by continent

Continent Percentage
Americas 44.84%
Europe 30.24%
Asia 18.76%
Oceania 3.28%
Africa 1.79%
(not set) 1.09%
Total 100.00%

Cities

A map of the cities can bee seen below

Here is the list of the top 15 cities, you can also see those in the map above

  1. London

  2. New York

  3. Bangalore

  4. Chennai

  5. Hyderabad

  6. Sydney

  7. Chicago

  8. Pune

  9. Mumbai

  10. Toronto

  11. New Delhi

  12. San Francisco

  13. Melbourne

  14. Paris

  15. Singapore

That is all for this post, tomorrow we are going to look at Mobile Devices, Operating Systems and Browsers