Yea.. SOUNDEX is fairly basic and probably best suited for US English pronunciations.

Have you had a chance to look at the links mentioned by Chris above?

Based on the sample names you've mentioned, SOUNDEX will work:

select SOUNDEX('Poonam') -- P550

select SOUNDEX('Punam') -- P550

select SOUNDEX('Veenita') -- V530

select SOUNDEX('Vinita') -- V530

select SOUNDEX('Amita') -- A530

select SOUNDEX('Ankita') -- A523

select SOUNDEX('Ramita') --...

This is a SQL Server forum so TSQL is the flavour of SQL used not MySQL

Create a VIEW?

SQL Server will consume memory...

Check out the following post that I started last July: http://www.sqlservercentral.com/Forums/Topic1337370-391-1.aspx

Chris@Home kindly provided a really good token matching algortihm and it's ultra fast as it's implemented as iTVF.

SOUNDX is rubbish....

You're almost there!

Try this:

CREATE FUNCTION dbo.rollavg (@data_in char(3))

RETURNS int

AS

BEGIN

DECLARE @data_out int

SET @data_out = (SELECT [/color]AVG(u.data) FROM (SELECT TOP 10 @data_in AS data FROM table01 WHERE pkart3='A' ORDER BY lfnr DESC)...

GilaMonster (4/3/2013)

---

Abu Dina (4/3/2013)

---

GilaMonster (4/3/2013)

---

If autogrow kicks in during peak usage time, the users may well notice a degradation in performance. If you grow the file manually at a quiet...

Even...

rob.phillips 38602 (4/3/2013)

---

Does changing the Initial (MB) move the entire database file to a contigous physical space if it's been fragmented with autogrowth already? Does autogrowth add a contiguous space...

Well if you have no natural primary key for your table then you can generate your own surrogate keys.

Careful with GUIDs though, they consume 16 bytes each and can...

theashishtrivedi (4/2/2013)

---

Thanks for reply.

I agree with your explanation and I do follow as you said. Can you tell me if there is any performance gain, if I maintain the length...

My understanding of this is as follows:

INCLUDED columns in the index go in the SELECT part of the query whilst the actual column that make up the index are used...

I had a similar issue last week with a table of 80 million+ rows which had several indexes with included columns. But now I remember I had to perform several...

Yes, I'm afraid it will.

nadersam (3/27/2013)

---

I am asking that because i have a big table with a column included...