XML FeedsEvery 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.
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
01. London
02. New York
03. Bangalore
04. Chennai
05. Hyderabad
06. Sydney
07. Chicago
08. Pune
09. 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
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.
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.