Browsing all articles tagged with Text
Sep
14

Google Ranking Tips – Anchor Text

Google Ranking Tips – Anchor Text

If you make a large number of directory submissions, website linkbacks and article submissions with the same anchor text, you could actually hurt your attempts at optimizing SEO.

What is anchor text? Anchor text is usually blue and underlined text. Underneath or behind the anchor text, there is a link to a website or article. The user doesn’t see the link details, he only sees the anchor text. The anchor text is what the user/reader clicks on to get more information.

Search engines often look at anchor text to determine what the link is about and thus infer the subject of the site to which the link points. It is widely believed that placing keywords in anchor text helps search engine ranking. (Keywords are the words people commonly use to search for information. For example, “Google Ranking Tips” are three keywords that work as a keyword phrase and are searched for frequently.)

If you submit an article to twenty different article sites, for example, with the same anchor text it may look like you are trying to manipulate the search engines. Additionally, if you trade links with several another sites, and your anchor text on every other site is the identical, then Google will notice this, and may penalize your site for trying to manipulate the search engine results.

A popular blogger trying to optimize his site for the keywords, “Internet Marketing Tips” made an offer to his bloggers. If they would link to his blog with a link that used “Internet Marketing Tips”, he would link back to them. Because this blogger got lots of linkbacks, and they all were with the anchor text, “Internet Marketing Tips”, there was a problem.

At first, his site was quickly ranked highly for his keywords “Internet Marketing Tips”. After a while, however, his ranking fell significantly. He just couldn’t determine what had happened. He got some advice from an SEO expert who explained the mechanics of what had happened. He asked some of the readers to make changes to the links pointing to his site. In no time at all, his site rankings improved.

Rather than making this mistake, make sure that some of the sites that link back to you have unique anchor text phrases. Here are some examples of varying the anchor text:

* “Search Engine Tricks to Use”,
* “Don’t try to trick Google”,
* “SEO Tricks to improve your rankings”

These examples of anchor text could all point to the same site, but they just use different keywords.

In short, make sure that you vary your anchor text. Vary your anchor text when making multiple submissions. It just looks fishy to the search engines.

Mar
21

Full Text Search In Sql Server 2005

Author admin    Category Google     Tags , , , ,

I was working on my second site recently. It provides a warehouse of projects, presentations and other resources. To enables users to find the relevant project i decided to put in a search box. Initially all seemed 5 min job. I quickly wrote a simple SELECT query and thought that job is done. But then i realized that it isnt as easy as it appears. Many beginners will find it hard to achieve a google like search in their site. There are two ways to include a search feature in your site.

1. Use google to embed a search box in your site. This will enable surfers to search your site as well as googles.

2. Use full text feature of SQL server to enable users to search content of your site.

Now the problem with the first solution is that it provides user an option to drift away from your site. Also the search results can be customized only to certain extent.

I prefer the second solution for real developers. After a bit of searching i found a simple way to achieve this. Using full text feature you can get a google like search box working on your site. Lets get to the code:

step 1. first create a database you want to use

create database database_name

step 2. use the database you created above

use database_name

step 3. create the table with one primary key

create table table_name(

column_name1 datatype constraints,

column_name2 datatype constraints,

column_name3 datatype constraints,

….

)

Following commands are TSQL commands and runs inbuilt SQL procedures

step 4. enable fulltext search for the database

EXEC sp_fulltext_database  ‘enable’

step 5. create a new catalog for the table you want to search

EXEC sp_fulltext_catalog ‘catalog_name’,'create’

step 6. create a unique index. the index must be made on a unique column(preferrably the primary key) of the table you want to search. Note: index have max size of 900 bytes so a comination of columns using more than 900 bytes can cause problem in updation and selection

CREATE UNIQUE INDEX index_name ON table_name(unique_column_name);

step 7. create fulltext search

EXEC sp_fulltext_table ‘table_name’,'create’,'catalog_name’,'index_name’

step 8. add columns you want to search. you can add multiple columns

Exec sp_fulltext_column ‘table_name’,'column_name’,'add’

step 9.full text index tracking can be set to auto, manual  or off. in auto mode whenever there is a change in database the index updates itself. in manual  mode you need to start updation. in this real time updation is not possible. you can manually update using following command

EXEC sp_fulltext_table ‘table_name’, ’start_full’

you can off the change tracking when you dont want the index to b updated(this itself defies the logic of fulltext search but in certain condition you may want to switch it off). to put the change tracking on auto mode use

ALTER FULLTEXT INDEX ON uploadedfiles SET CHANGE_TRACKING AUTO

step 10. this is the last step. you need to activate the search.

EXEC sp_fulltext_table ‘uploadedfiles’,'activate’

Now the table is ready fo searching. but for searching you cannot use normal select query of types :         Select * from table_name where column_name LIKES ‘% QUERY %’. this again looks for exact match.

to search occurrence of multiple words we need to use CONTAIN command

select * from table_name where contain(column_name,’query’)

Above command search for query in mentioned columns but it doesnt require words to be present in same order eg. if you search for ‘cat and mouse’ and if column contains ‘mouse and cat’ then the row will be returned but if all the words in query are not present in same column then row wont be returned like for row containing ‘mouse and elephant’ wont be returned. for success of such queries you need to search words separately using AND

Select * from table_name where contain(column_name,’word’) and contain(column_name,’word’)

Exec sp_fulltext_column ‘uploadedfiles’,'description’,'add’

And thats all. now you will be able to search your site on multiple columns.

To check a working example visit http://www.academia.in

———————————————————————————————————————

download free projects, presentations, ebooks, papers. share with your friends, sms your buddies only@ http://www.academia.in

Mar
20

Buy Text Links for Great Search Engine Ranking

All of the SEO experts agree: buy text links for great search engine ranking. It is what they do, and they charge good money to do it. The SEO experts know how to drive traffic to websites and raise rankings by buying text links from high ranking sites.


Search engine rank is raised when other, high ranking sites, link to yours. The little Google spiders crawl the popular websites, and then they crawl the sites that they are linked to, and viola! You have been noticed!


Each site that links to yours is viewed as a sort of vote in your site’s favor. The rank of the site linking to yours determines the weight that its vote carries. A link from grandma’s blog about her pet hamsters will not be seen as a huge vote, but a link from, say, Amazon would carry quite a bit of influence and tell the search engines that you are someone special.


That is what we all strive for when designing our websites, isn’t it? We work hard writing quality content and carefully select good keywords for search engine recognition, but sometimes all that is not enough. Sometimes the best option is to buy text links for great search engine ranking.


There are a myriad of sites on the internet advertising text linking to improve your rank, but how to do you choose? Some of these sites simply sell a link for a one time fee, and others charge you a monthly fee. Some work through a text link broker, and others allow you to work directly with the site selling the links. It really depends on what you want personally, because they all do the same thing essentially.


First, you must choose a page to link from and the best strategy is to choose a page with content that is relevant to your own so you will not only get the search spiders, but also traffic. Then look at the page’s rank to make sure that it is higher than your own. The higher ranking pages will be better, but they will also cost more, so you have to decide what to choose based on your own budget.


Once the text links or backlinks are purchased, most services will have them up and running very quickly. It is difficult to tell how quickly you will see an increase in page rank, as most search engines update ranking erratically, sometimes waiting a few months before doing an update. Just be patient and know that next time they update the rankings, you are sure to see results. If you buy text links for great search engine ranking, you will not be disappointed.

Mar
11

Avoid Hidden Text If Your Dream is to Get Higher Page Rankings

In any Internet search engine optimization endeavor, hidden text has often been conceived as a challenge faced by search engines and webmasters. As spammers have shown a great inclination towards hidden text to stuff keywords into their pages to get high rankings on search engines, search engines are now figuring out when and how spammers do it. However, there are a number of hidden texts some of which are even tried by web designers for legitimate reasons that have nothing to do with the business of getting high ranking on a search engine like that of Google.

Also known as ‘invisible’ or ‘fake’ text, hidden text on a web page is visible to search engines but not to website visitors. Most commonly, hidden text is created by setting the font color same as the background color thus making the text invisible unless the user highlights it. There are some other ways to create hidden texts which are:

By setting the font size to 0 or to a negative number. By using noscript text like <script type=”text/javascript”> <!– [removed](“This text is not hidden”) //–> </script> <noscript>This is hidden text</noscript>

Often web sites use hidden text to disguise spoilers for readers who do not wish to read that text. Hidden text in online activity is also used to hide data from users who are less internet-savvy. And as it has already been stated, hidden text is one of the favorite tools for spammers that they implement to get higher ranks in search engines. However, search engine major Google has taken bold steps to prevent this spamming effort by parsing the color of text as it indexes it. Therefore a search engine optimization specialist will never encourage you to go for these tactics. Because of Google’s initiative against spamming, Search engine optimization companies are now concentrating on the genuine tactics for getting higher search engine rankings, not on hidden text.