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 | <th>
Percentage
</th>
</tr>
<tr>
<td>
<a href="/summary.php">All Blogs</a>
</td>
<td>
15.98%
</td>
</tr>
<tr>
<td>
<a href="/index.php/ITProfessionals/EthicsIT/collection-of-puzzles-for-programmers">Collection Of Puzzles For Programmers</a>
</td>
<td>
11.40%
</td>
</tr>
<tr>
<td>
<a href="http://forum.lessthandot.com/search.php?search_id=active_topics">View active topics</a>
</td>
<td>
8.92%
</td>
</tr>
<tr>
<td>
<a href="http://lessthandot.com/">Launchpad</a>
</td>
<td>
7.90%
</td>
</tr>
<tr>
<td>
<a href="http://sqlcop.lessthandot.com/">SqlCop</a>
</td>
<td>
6.15%
</td>
</tr>
<tr>
<td>
<a href="/index.php/ITProfessionals/ProfessionalDevelopment/should-i-abandon-vb-net">Should I abandon VB.Net?</a>
</td>
<td>
4.99%
</td>
</tr>
<tr>
<td>
<a href="http://lessthandot.com/">Index page</a>
</td>
<td>
4.80%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/calculating-mean-median-and-mode-with-sq">Calculating Mean, Median and Mode with SQL Server</a>
</td>
<td>
4.62%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1">The Ten Most Asked SQL Server Questions And Their Answers</a>
</td>
<td>
4.60%
</td>
</tr>
<tr>
<td>
<a href="/index.php/ITProfessionals/ITProcesses/trying-the-stand-up-desk">Trying the Stand-Up Desk</a>
</td>
<td>
3.09%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr">SQL Server Zipcode Latitude/Longitude proximity distance search</a>
</td>
<td>
3.06%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DBProgramming/create-xml-files-out-of-sql-server-with-">Create XML Files Out Of SQL Server With SSIS And FOR XML Syntax</a>
</td>
<td>
2.79%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DBAdmin/title-12">6 ways to import data into SQL Server</a>
</td>
<td>
2.30%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/sql-server-2008-proximity-search-with-th">SQL Server 2008 Proximity Search With The Geography Data Type</a>
</td>
<td>
2.29%
</td>
</tr>
<tr>
<td>
<a href="/index.php/ITProfessionals/EthicsIT/how-to-enable-godmode-on-windows-7">How To Enable GodMode On Windows 7</a>
</td>
<td>
2.25%
</td>
</tr>
<tr>
<td>
<a href="/index.php/ITProfessionals/ProfessionalDevelopment/be-mindful-with-your-code">Be Mindful With Your Code</a>
</td>
<td>
2.21%
</td>
</tr>
<tr>
<td>
<a href="http://wiki.lessthandot.com/index.php/Kill_All_Active_Connections_To_A_Database">Kill All Active Connections To A Database – Wiki</a>
</td>
<td>
2.19%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DBProgramming/MSSQLServer/delete-all-data-in-database-when-you-hav">Delete all data in database (when you have FKs)</a>
</td>
<td>
1.81%
</td>
</tr>
<tr>
<td>
<a href="http://wiki.lessthandot.com/index.php/SQL_Server_Programming_Hacks_-_100%2B_List">SQL Server Programming Hacks – 100+ List – Wiki</a>
</td>
<td>
1.80%
</td>
</tr>
<tr>
<td>
<a href="http://forum.lessthandot.com/viewforum.php?f=102">View forum – Programmer Puzzles</a>
</td>
<td>
1.76%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/think-carefully-which-sql-server-you-wan">Working with 32 bit providers and 64 bit SQL Server</a>
</td>
<td>
1.73%
</td>
</tr>
<tr>
<td>
<a href="/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server">Extracting numbers with SQL Server</a>
</td>
<td>
1.71%
</td>
</tr>
<tr>
<td>
<a href="http://wiki.lessthandot.com/index.php/Cursors_and_How_to_Avoid_Them">Cursors and How to Avoid Them – Wiki</a>
</td>
<td>
1.69%
</td>
</tr>
|---|
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 | <th>
Percentage
</th>
</tr>
<tr>
<td>
United States
</td>
<td>
36.73%
</td>
</tr>
<tr>
<td>
India
</td>
<td>
9.39%
</td>
</tr>
<tr>
<td>
United Kingdom
</td>
<td>
7.56%
</td>
</tr>
<tr>
<td>
Canada
</td>
<td>
3.55%
</td>
</tr>
<tr>
<td>
Germany
</td>
<td>
2.80%
</td>
</tr>
<tr>
<td>
Australia
</td>
<td>
2.63%
</td>
</tr>
<tr>
<td>
Belgium
</td>
<td>
1.78%
</td>
</tr>
<tr>
<td>
France
</td>
<td>
1.71%
</td>
</tr>
<tr>
<td>
Netherlands
</td>
<td>
1.70%
</td>
</tr>
<tr>
<td>
Brazil
</td>
<td>
1.52%
</td>
</tr>
<tr>
<td>
Italy
</td>
<td>
1.43%
</td>
</tr>
<tr>
<td>
Spain
</td>
<td>
1.39%
</td>
</tr>
<tr>
<td>
Poland
</td>
<td>
1.20%
</td>
</tr>
<tr>
<td>
Sweden
</td>
<td>
1.20%
</td>
</tr>
<tr>
<td>
Russia
</td>
<td>
1.15%
</td>
</tr>
<tr>
<td>
(not set)
</td>
<td>
1.07%
</td>
</tr>
<tr>
<td>
South Africa
</td>
<td>
1.01%
</td>
</tr>
<tr>
<td>
Mexico
</td>
<td>
0.86%
</td>
</tr>
<tr>
<td>
Turkey
</td>
<td>
0.84%
</td>
</tr>
<tr>
<td>
Philippines
</td>
<td>
0.71%
</td>
</tr>
<tr>
<td>
Israel
</td>
<td>
0.70%
</td>
</tr>
<tr>
<td>
Portugal
</td>
<td>
0.70%
</td>
</tr>
<tr>
<td>
New Zealand
</td>
<td>
0.66%
</td>
</tr>
<tr>
<td>
Denmark
</td>
<td>
0.65%
</td>
</tr>
<tr>
<td>
Switzerland
</td>
<td>
0.65%
</td>
</tr>
<tr>
<th>
Total
</th>
<th>
100.00%
</th>
</tr>
|---|
Here is the breakdown by continent
| Continent | <th>
Percentage
</th>
</tr>
<tr>
<td>
Americas
</td>
<td>
44.84%
</td>
</tr>
<tr>
<td>
Europe
</td>
<td>
30.24%
</td>
</tr>
<tr>
<td>
Asia
</td>
<td>
18.76%
</td>
</tr>
<tr>
<td>
Oceania
</td>
<td>
3.28%
</td>
</tr>
<tr>
<td>
Africa
</td>
<td>
1.79%
</td>
</tr>
<tr>
<td>
(not set)
</td>
<td>
1.09%
</td>
</tr>
<tr>
<th>
Total
</th>
<th>
100.00%
</th>
</tr>
|---|
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
London
New York
Bangalore
Chennai
Hyderabad
Sydney
Chicago
Pune
Mumbai
Toronto
New Delhi
San Francisco
Melbourne
Paris
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.
