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

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.

• 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

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!

Visual Studio 2010 and .NET Framework 4 focuses on the core pillars of developer experience, support for the latest platforms, targeted experiences for specific application types, and core architecture improvements.

Check out the following links:

What’s New in Visual Studio 2010

What’s New in the .NET Framework 4

Download Visual Studio 2010 and .NET Framework 4 Beta 1

Declare @intPointer int

exec sp_xml_preparedocument @intPointer output, @strXML

INSERT into employee

SELECT  EmpName, EmpSalary

FROM OpenXml(@intPointer,’/root/emp’,2)

WITH EmpName varchar(20) ‘@EmpName’ , EmpSalary varchar(20) ‘@EmpSalary’)

exec sp_xml_removedocument @intPointer

———————–

EXEC InsertEmployees ‘<root><emp EmpName=”Srinath” EmpSalary=”10000″ /><emp EmpName=”sree” EmpSalary=”15000″ /></root>’

sp_xml_preparedocument

Reads the XML text provided as input, parses the text by using the MSXML parser (Msxmlsql.dll), and provides the parsed document in a state ready for consumption. This parsed document is a tree representation of the various nodes in the XML document: elements, attributes, text, comments, and so on.

sp_xml_preparedocument returns a handle that can be used to access the newly created internal representation of the XML document. This handle is valid for the duration of the session or until the handle is invalidated by executing sp_xml_removedocument.

OPENXML

OPENXML provides a rowset view over an XML document. Because OPENXML is a rowset provider, OPENXML can be used in Transact-SQL statements in which rowset providers such as a table, view, or the OPENROWSET function can appear.

Sample:

OpenXml(@intPointer,’/root/emp’,2)

WITH EmpName varchar(20) ‘@EmpName’ , EmpSalary varchar(20) ‘@EmpSalary’)

sp_xml_removedocument

Removes the internal representation of the XML document specified bythe document handle and invalidates the document handle. To avoidrunning out of memory, will run sp_xml_removedocument to free up the memory.

Few collection of jQuery samples are given below. Also check this link : JQuery Samples – Advanceed

Menus, Navigations

jQuery Tabs Plugin – awesome! . [demo nested tabs.]

another jQuery nested Tab Set example (based on jQuery Tabs Plugin).

jQuery idTabs.

jdMenu – Hierarchical Menu Plugin for jQuery.

jQuery SuckerFish Style.

jQuery Plugin Treeview.

treeView Basic.

FastFind Menu.

Sliding Menu.

Lava Lamp jQuery Menu.

jQuery iconDock.

jVariations Control Panel.

ContextMenu plugin.

clickMenu.

CSS Dock Menu.

jQuery Pop-up Menu Tutorial.

Sliding Menu.

Form Validation

jQuery Validation.

Auto Help.

Simple jQuery form validation.

jQuery XAV- form validations.

jQuery AlphaNumeric.

Masked Input.

TypeWatch Plugin.

Text limiter for form fields.

Ajax Username Check with jQuery.

Few more samples:

Selection – CSS

Selection – Attributes

Selection – Forms

Selection – Custom

Selection – Traversal Methods

Element Manipulation

Document Manipulation

Events

Effects

Ajax

Click here for more details.,.

Eg: Deletes duplicate Employee names

DELETE FROM Employee WHERE Employeeid IN (
SELECT Employeeid
FROM
(SELECT
Employeename,
Employeeid,
rank() OVER ( PARTITION BY Employeename ORDER BY Employeeid) [ROW_NUMBER]
FROM Employee
)
[Test]
WHERE ROW_NUMBER > 1
)

Query to slect duplicate Employee names:

SELECT Employeeid
FROM
(SELECT
Employeename,
Employeeid,
rank() OVER ( PARTITION BY Employeename ORDER BY Employeeid) [ROW_NUMBER]
FROM Employee
)
[Test]
WHERE ROW_NUMBER > 1

The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are DuplicateColumn1 and DuplicateColumn2.

DELETE
FROM Table_NAME
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM Table_NAME
GROUP BY DuplicateColumn1, DuplicateColumn2)

2. Query to find the Nth largest and smallest element.

nth largest
select min(Salary) from employee where Salary in (select top n Salary from employee order by Salary desc)

nth smallest
select max(Salary) from emp where Salary in (select top n Salary from employee order by Salary asc)

3. Query to display the no. of occurence of an item in a database table.

select EmployeeName,count(EmployeeName)
from Employee
group by EmployeeName

Similarly, we can find the elements with more than one occurence.

select EmployeeName,count(EmployeeName)
from Employee
group by EmployeeName
having count(EmployeeName) > 1

4. How to find Currently Running Queries.

SELECT sqltext.TEXT ‘Current running queries’,
req.session_id [Session Id],
req.status [Status],
req.command [Command],
req.cpu_time [CPU Time],
req.total_elapsed_time [Total Elapsed Time]
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

5. Query to display sequential number of a row of a result set, starting at 1 for the first row.

SELECT EmployeeName, ROW_NUMBER() OVER(ORDER BY EmployeeID DESC) AS ‘Row Number’
FROM Employees