I used to create temporary tables and subqueries to add a row number to every row in the result set. But somedays ago, I came across to the Row_Number() function provided in Sql Server, which simply constructs the row number column on the fly as part of the query. But a question might have arosed in your mind, What is the use of adding a Row_Number, when we have serial number associated with every row. There are several situation, where we need to query against the row number.(we can't query against a serial number)

We have been using Linux for more then 18 years, without paying a single penny, Thanks to Open Source. There are more than 137000 registered machines, which are using Linux as their Operating System. Linux is the work of thousand of developers working as a Community. But have you ever wondered, what would be the development cost of Linux.

When I launched this blog in Drupal, I knew, I would be modifying its "Recent Comments" Block someday. I did'nt like Drupals default "Recent Comments" Block. It only display, subject of the comment with its posted time.

But I wanted a lot more. I wanted to display the "'comment author'(linking to author's homepage) added a 'comment' (linking to comment) to 'Title of the post' (linking to the post) (Time ago). I also wanted to separate Comments according to the node types. Comments on the blog entry and Forums should be shown in a differnt blocks. 

When I was developing this site, I knew I would be publishing a lot of Source Code. After some googling I foung GeSHi Filter for Source Code Syntax Highlighting. This module integrates the third party PHP library GeSHi (Generic Syntax Highlighter) into Drupal. GeSHi Filter, syntax highlight your source code between <blockcode>tag.

Its have been quite a time when Orkut launched Promote feature. In a recent announcement Orkut release its Bookmarklet feature. Now you can share any link with your friends on orkut by just clicking a Button. Visit this link to add a new button to your bookmark toolbar. Link shared will appear on your updates section as well as promote section in orkut.

Understanding Indexes

Indexes speed up the querying process by providing filtered access to rows in the data tables (just like book’s index) if they are used efficiently.

Indexes are created on columns in tables or views.

1. Define an ASP.NET web site.
2. Create two pages within the site. The first page will contain an ASP.NET Web Form that will post back to itself and then redirect to the second page.

   Note: The reason this example uses two pages is to prove that a session variable is available to a second, third, fourth, etc. page in the web site. Request variables, which are an alternative to session variables, cannot be carried over from an ASP.NET Web Form on one page to a second page

Google now offers URL Shortening Service name Google URL Shortner for Google Toolbar and FeedBurner. Google Toolbar now use Goo.gl for link sharing. In an announcement today Google Launch this service. Google put three points to use Google URL Shortner over Other URL Shortening Services.

If you are running a ADSL or ADSL2 Modem and your internet connection is not working, here are some basic steps which you can follow before calling any techsupport guy.

These Steps worked for MTNL, BSNL, Verizon, AOL and other telecom companies which provide internet connection through a phone line.