Thursday, October 15, 2009

How to do Keyword Analysis

Keyword Analysis is something very important when you even start thinking about creating a website or a blog. There is no definite tool which explains the in and outs of Keyword Research however the below resources are really very useful to start with:

Web Master World

SEO Guide

Make use of them & increase your PR with the help of Organic traffic.

The title says it all! :)



We all know that, a unique constraint nominates a column (or combination of columns) for which the value must be different for every row in the table. If based on a single column, this is known as the key column. If the constraint is composed of more than one column (known as a composite key unique constraint) the columns do not have to be the same data type or be adjacent in the table definition.

An oddity of unique constraints is that it is possible to enter a NULL value into the key column(s); it is indeed possible to have any number of rows with NULL values in their key column(s). So selecting rows on a key column will guarantee that only one row is returned—unless you search for NULL, in which case all the rows where the key columns are NULL will be returned.

Unique constraints are enforced by an index. When a unique constraint is defined, Oracle will look for an index on the key column(s), and if one does not exist it will be created. Then whenever a row is inserted, Oracle will search the index to see if the values of the key columns are already present: if they are, it will reject the insert.

The structure of these indexes (known as B*Tree indexes) does not include NULL values, which is why many rows with NULL are permitted: they simply do not exist in the index. While the first purpose of the index is to enforce the constraint, it has a secondary effect: improving performance if the key columns are used in the WHERE clauses of SQL statements. However, selecting WHERE key_column IS NULL cannot use the index because it doesn’t include the NULLs and will therefore always result in a scan of the entire table.

Read more on Oracle - B-Tree Index and How b-tree database indexes work and how to tell if they are efficient

Do you think you can make a better fast-booting, Chrome-focused OS than Google? Do you want to craft a custom Linux system that boots from a USB stick?

SUSE Studio gives you 15 GB to do exactly that, and you do it all online. Even if you don't know all that much about Linux, it's pretty easy to build a system you can boot from a USB stick or live CD/DVD, run inside a virtual machine program, or actually install it—or, heck, even test it out in your web browser.

Check SUSE Studio for more details

Sounds fake? I don’t give any bull**** Lol Well, read on...

I have been a member on this forum for almost 4 months and they are no scam. They do pay and even have payments proofs.

These are the five simple steps you need to do:

  1. Go to Business Advice Forum
  2. Select the check box and click on Register button
  3. Fill up the mandatory details and leave other fields as such
  4. Finally, click on Complete Registration button
  5. Once you have joined them, you will be required to make 10 posts. Section doesn't really matter. You can post on any section or even create a new thread if you want to.

That is all, now you can check "BAF $25 Contests AND Free $10,000 Draw Entry" section of that forum and participate in the contest. You win; you will be awarded with the prize money. Payment is through Paypal.

Gist of the nature of contests they conduct:

The nature of contests is really simple. Few of the previous closed entries are like

  • the Admin (Fergal) will pick a blog and ask you to write your opinion on it OR
  • Create two new useful threads. The best thread wins
  • Just make a reply to a thread. The useful & sensible reply wins, etc

Current $25 Contest

Are you a fan of Google Trends? If yes, you may win the contest just for saying what is so surprising for you about Google Trends.

So, what are you still waiting for? JOIN BAF - Business Advice Forum NOW & bag prizes.

Happy whining, if you don’t believe in this. Happy winning, otherwise :)