Last week i came across FB Developer’s Code Challenge…Here is the question i got ::

Question :: 1

Given a list of words, L, that are all the same length, and a string, S, find the starting position of the substring of S that is a concatenation of each word in L exactly once and without any intervening characters.  This substring will occur exactly once in S.

Example:
L: “fooo”, “barr”, “wing”, “ding”, “wing”
S: “lingmindraboofooowingdingbarrwingmonkeypoundcake”
                 fooowingdingbarrwing
Answer: 13

L: “mon”, “key”
S: “monkey
    monkey
Answer: 0

L: “a”, “b”, “c”, “d”, “e”
S: “abcdfecdba”
         ecdba
Answer: 5

The first line of input specifies L, it will contain between 1 and 100 space-separated words, each between 1 and 10 characters long.

The second line of input specifies S, the line will contain a single word up to 1 million characters long.

The characters in both L and S should be treated as case-sensitive.

Download the TestCases here…

Techies…Find out the solutions

Google has entered the online music market to allow US consumers to search using song titles, artists or snippets of lyrics.

The top search engine has said the service will offer an alternative to the illegal file-sharing which record companied have been trying to stop.The Google music offering will also spring up in peer-to-peer file searches, meaning people will be able to decide on an alternative to pirated music.

According to Google, the words “music” and “lyrics” are among the top 10 search terms in its web statistics.The company will now find partners in other countries to allow international consumers to use the service.

“This feature doesn’t just make search better. It also helps people discover new sources of licensed music online while helping artists to discover new generations of fans and reconnect with longtime listeners,” Google said in a statement.

Google has made available a video preview of its music search feature which is viewable below.

The music features will not be available to users elsewhere in the world. But Google is open to talking with possible overseas partners, said Marissa Mayer, vice president of search product and user experience at Google.

“This is pushing search traffic and business opportunities downstream to online partners and artists and labels, so we’re happy to provide a great music experience and also direct lots of music-seeking traffic to partners that can take it from there and convert it to great music discovery,” said R.J. Pittman, product manager for the music service at Google.

Today, i come across some good articles on JSON. And here is the link where JSON is explained so well.  Also you can find some good collection of related links…

Best Practices for Query Optimization

• Table should have primary key
• Table should have minimum of one clustered index
• Table should have appropriate amount of non-clustered index
• Non-clustered index should be created on columns of table based on query which is running
• Following priority order should be followed when any index is created a) WHERE clause, b) JOIN clause, c) ORDER BY  clause,  d)  SELECT clause
• Do not to use Views or replace views with original source table
• Triggers should not be used if possible, incorporate the logic of trigger in stored procedure
• Remove any adhoc queries and use Stored Procedure instead
• Check if there is atleast 30% HHD is empty – it improves the performance a bit
• If possible move the logic of UDF to SP as well
• Remove * from SELECT and use columns which are only necessary in code
• Remove any unnecessary joins from table
• If there is cursor used in query, see if there is any other way to avoid the usage of this (either by SELECT … INTO or INSERT … INTO,     etc)

Source : SqlAuthority

Windows 7 is finally released into the wild!  So far the operating system has received great reviews around the web. Amazon even said that Windows 7 is bigger than Harry Potter, so things are looking bright for them .

Many say that Windows 7 is what Windows Vista should have been, an optimized operating system that combines the looks of today with interesting new features and less bloat.

Here are the things that I personally like in Windows 7:

* Automatic digital camera (and other devices) recognition with proper actions displayed (e.g. copy photos from digital camera to the               computer system). No driver installation or third party software needed to do that.
* The operating system feels more responsive and seems to run better on low-end hardware than Vista
* Better troubleshooting options
* The new taskbar. It takes a while to get used to the new features but they are very handy (e.g. pinning software to the taskbar)                    once you get used to them
* Light theme customizations without system file patching
* Search Connectors to search the Internet from within Windows Explorer
* Better 64-bit support (meaning developers who want a certificate need to provide 32-bit and 64-bit editions of their programs)
* Home Group feature for easier home network management and creation

Also Check Windows 7 Blog

Snip from the PCMAG:

“Microsoft’s decision to leave Windows XP users behind, with no easy upgrade path to Windows 7, is, possibly, the sole mistake of an otherwise pitch-perfect product development and launch campaign.

Yes, I know there’s precedent for Microsoft not helping customers upgrade from multi-generations-old operating systems. When XP shipped in October of 2001, Windows 3.1 and even Windows 95 were left behind. The exact phrasing Microsoft uses in its literature is: “No Supported Upgrade Paths.” When Vista shipped in January 2007, XP had multiple paths, but Windows 2000 (and older OSs) were left out in the cold. more..“

Have you already installed W7 on your computer? Let me know what you think in the comment section!