I’ve just been struggling to enable full-text search on my installation of SQL Server 2005 Express Edition, and so want to share the solution.
If, like me, the ‘Use full-text indexing’ checkbox was greyed out under Database > Properties > Files, you first need to test whether Full-Text Indexing is installed or not. To do this, execute the query.
use [dbname]
select fulltextserviceproperty(’isfulltextinstalled’)
If this returns 0, you need to install Full-Text Search.
Firstly, did you install SQL Server 2005 Express Edition Advanced Series? Only the Advanced Series contains full-text. If not, you may need to reinstall.
However if so, then you just need to change the installation to include Full-Text Indexing. But if you originally installed from a download from the above link (most of you) then you’ll find that when you try to modify the installation via Control Panel > Applications / Programs, Windows prompts you for the installation file ’sqlrun_sql.msi’. This is because the download unpacked the installation files to a temporary folder which can no longer be found.
To resolve this issue, you need to download the file again from the link above, move it to a folder, and unzip (I used WinRAR). Then point Windows to the sqlrun_sql.msi file (under /setup, wherever you unzipped the download) when it prompts you for the installation file.
For additional info, see here.
For additional support setting up Full-Text Search once installed, watch this video on the topic from Micosoft, BUT I think you’ll find my new tutorial on seting up Full-Text Search in SQL Server 2005 Express much quicker and more intuitive to be honest..
These statistics source from a compilation of SERPS behaviour studies for which I’ve listed source information at the end of the article. If you disagree with a figure, or have additional figures or sources, please do post them to the discussion.
- 42% of search users click the top-ranking link. 8% click the second-ranking link, and the click-through rate (CTR) continues to drop thereof.
- When these two top-ranking links are artificially switched, the click-through ratio of 42-8% drops to 34-12%, demonstrating the importance of engaging copy in addition to rank position.
- 62% of search users click a link on the first page of search results
- 23% of searches progress to the second page. Presumably the difference between 62% ans 23% stems from searchers trying either another keyword or another engine, or giving up.
- 80% f unsuccessful searches are followed with keyword refinement.
- 41% of searches unsuccessful after the first page choose to refine thir keyword search phrase or their chosen search engine.
- 77% of search users choose organic over paid listing when searching, 67% choose organic search when purchasing.
- When the searcher is purchasing, organic click-through generates 25% higher conversion rates than equivalent Pay-Per-Click (PP) click-through.
- 40% of SEO campaigns aware of their ROI achieve returns in excess of 500%, while only 22% of PPC campaigns were able to achieve this value.
- Daily use of search engines rose from 33% in 2002 to 59% in 2005. The average day in 2005 reported 60 million people using a search engine. As of March 2007, Google accounts for 64% of US searches and 77% of UK searches
The validity of these statistics depend on various experimental factors (i.e. large, representative samples of searchers/searches), and on accurate statistical analysis.
For more in depth analysis, the sources for this article were:
Please post addition figures or sources, or your view, in the comments.
The latest figures on Google’s market share compared to its primary search competitors Yahoo, MSN, and Ask (formerly Ask Jeeves) have been published by Hitwise. As always, the numbers are astounding, revealing that Google holds a 77% market share, meaning overthree quarters of UK internet searches are made through Google. Yahoo is now holding 8%, and while MSN and Ask are both at 5% and falling.
Comparing the UK to the US figures, for which Google has just broken 66.6% or two thirds market share, it’s clear that UK internet searchers even more than US searchers turn first to Google.
A collective 23% is not to be sniffed at, but clearly firms services the UK market and requiring SEO services should look first to SEO specialists with strong results in google.co.uk.
Technorati Tags: seo, uk, search engine market, google, yahoo, msn
“Web Standards” is like another of these modern-day web buzzwords, like “Web 2.0″ and “The Blogosphere”. But buzzwords become popular for a reason - let me give this one a simple definition, and explain the business benefits of web standards, namely reduced website costs and risks.
Web standards are, quite simply, a set of coding guidelines developed by a consortium of experts to reduce the risks involved in producing a website. The simple principle is that if everybody codes in the same way, the standard way, then everybody is compatible. More >>
