Mens Room Etiquette

Although the animated movie contain some silly shots, yet worth watching as it tells us some do's and do nots in a Male RestRoom.
Source : youtube.com

Google News Archive

Google expanded its Google News service with a provision to search the past.As part of it has indexed 200 years of history from various resources like Gaurdian,NY Times,Washington Post,Time.....The Hindu,Deccan Herald etc.,Its a great source of information for those who would like to dig the past to know about their place,people,incidents etc, which otherwise want us to go to some big libraries.Most of the news happened during the last 15-20 years is availbale for free.But gaining access to (some of the ) pre 1990 news , needs to subscribe to the mother site.Information indexed from some of the portals like Time and UK's Guardian newspaper allows to access most of the information for free.Overall its great service from the Google stable.

Some example archive searches are given here
News about Windows 98 when it was released.
World War I
Independent India

Google News Archive Link

Nokia Tips

Some of the useful shotcuts for your Nokia phone

1] Press and hold a number key (between 2 to 9), it will yake you to the Speed Dial number attached to that number key.
2] Press and Holding of the Number key 1 will take to Voice MailBox.
3] Press and Holding of the Number key 0 will take to Home Page(If you GPRS enabled on your mobile).
4] Press and Holding of the special key * will take to Nokai home Page (If you GPRS enabled on your mobile).
Some Must Know Nokia Codes
1] *#06# - International Mobile Equipment Identity (IMEI Number)
2] *#7760# - Production Serial Number
3]*#92702689# - Fetches some of the useful information like lifetimer,Serial no,Made Date etc.,

Sending large files

Gigasize, here comes another portal for us to send large files across the web.It comes in three variants Free center(no registration required),Free account and premium service.The difference among them lies in the size of attachment,number of days file is kept active on the server and obviously the price etc.For complete comparison of the services click here

Related
youSendit

Wipro WASE 2006

Wipro WASE is a 4 year MS program from BITS ,Pilani , with the full fee borne by the IT giant Wipro plus an attractive stipend every month.
Interested candidates need to apply here (within a week).Selected candidates will be called for a test conducted at 5 or 6 major cities.
Eligibility : BSc(CS/IT/Electronics/Physics/Maths/Statistics)/BCA/BCM students .......
For More Details please refer other details or This wednesdays Time Of India

Table Indices

Consider the sample Table empTable and a select * from empTable fetched me the following results. It shows the rows are organized by the LastName column. For information, LastName is my Clustered Index key. For now this is the only index I have on this table.

Now Issue the following query "select * from emptable where age BETWEEN 16 AND 19".This will fetch me the following data.

But the point of concern here is performance and the usage of indices.To knows it I enquired for the estimated execution Plan.

It shows as below: Here it is scanning the table which is organized by the Clustered index. This is very much similar to table scan. The cost field shows 0.03767 units.

With an Index on Age field

Try to create an index on the column Age. Issue the previous query again, now, the estimated execution Plan is shown as below. It is split into to two tasks
1) Index Seek
Index seek goes through the Index structure which we created for the column and notes down the ROWIDs or Clustering Keys of the rows in table matching the selection criteria.
2) BookMark Lookup. Uses this ROWIDs or Clustering Keys to fetch the actual row in the table.
The cost field shows: 0.00651 units.

How it works

When the query is passed to the database, based on the columns in the WHERE clause fields are compared against existing indices. In our case the WHERE clause contains the age and it matches the just now created Index. So it is should be selected.

The index structure will usually be some variant of B/B+ tree, with each node contains a pointer called ROWID or Clustering Key pointing to the physical location of the row in the table. This pointer can be used during the BookMark Lookup phase to fetch the row.
Obviously going through the Tree structure is quicker compared to scanning the entire table. Hence using indices will improve the performance.

Mobile Quiz

Today mobile phones have occupied an irreplaceable place in our daily life. People got so addicted to it that, it has become a major time pass activity to talk to someone via a Mobile phone and at any time it will be locked in one of our hands.....Be it good or bad, its not the concern of this article.....but mobile is now an invaluable gadget. Here is a 5 question quiz from rediff to test what we know about the mobile phones. Test yourself.
Mobile Quiz

Web2.0 Logo Creator

Create a logo for your weblog or site by entering the name of your site.It allows you to add simple Graphics like..reflections,Beta tag.You can also use it to create image form for your emails,etc.,
Test try it here: Web2.0 Logo
Related
Email Icon Generator