I rebooted the server and ran one test - 29 secs, then immediately ran a second test - 25 secs.

Still quite a bit slower than the desktop!

Both tests were done directly on the desktop and on the server, not across the network.

The times were provided by SSMS.

Tables, indexes etc.. were exactly the same.

Chris Morris-439714 (1/15/2010)

---

This bit...

SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM outputresume3

WHERE ((contains (originalresume, '"j2ee" and "java"'))

AND (currentdateout BETWEEN '2000-01-01' AND '2010-01-06'))

change it...

Chris Morris-439714 (1/15/2010)

---

Guilty of cantankerism as charged -...

After 25 years of dealing with IT people, I guess sometimes one can get cantankerous.

Thanks to all the constructive contributors!

david.tyler (1/14/2010)

---

I wouldn't waste time on clowns that are obviously not professionals. This site houses professionals helping other professionals. There are professionals with varying levels of experience and then there's...

A few months ago, a forum member suggested reducing the size of the email fields from 1000 to something more reasonable.

So i created a TestDB that is an exact copy...

Thanks!

Apologies i missed you question - yes they can

Selection Criteria can be:

Email...

GilaMonster (1/13/2010)

---

ifila (1/13/2010)

---

What performance improvement might that provide?

BTW based on some initial performance testing with Gail's solution:

If i set TOP 60000 using her query it takes 8 seconds to get...

Chris Morris-439714 (1/13/2010)

---

ifila (1/13/2010)

---

Lynn Pettis (1/13/2010)

---

Could you please explain what you are trying to achieve? What is the business case for this query (now I'm starting to sound life...

Lynn Pettis (1/13/2010)

---

A count of unique email addresses, I am assuming as well. Does the user have the option to restrict the date range on the search? YES

If so,...

GilaMonster (1/13/2010)

---

Try this then

SELECT COUNT(Email) AS NumberOfEmails -- get the count

FROM (

SELECT DISTINCT TOP 15 Email -- get 15 unique emails

FROM (

SELECT Email1,Email2,Email3, Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM...

Lynn Pettis (1/13/2010)

---

Could you please explain what you are trying to achieve? What is the business case for this query (now I'm starting to sound life Jeff Moden)? ...

Lynn Pettis (1/13/2010)

---

ifila (1/13/2010)

---

create TABLE #OutputEmails

(

Email1 nvarchar(1000),

Email2 nvarchar(1000),

Email3 nvarchar(1000),

Email4 nvarchar(1000),

Email5 nvarchar(1000),

Email6 nvarchar(1000),

Email7 nvarchar(1000),

Email8 nvarchar(1000),

Email9 nvarchar(1000),

Email10 nvarchar(1000)

);

INSERT INTO #OutputEmails SELECT Email1,Email2,Email3,Email4,Email5,Email6,Email7,Email8,Email9,Email10 FROM OutputResume3

where (contains (originalresume, '"livelink" and "java"'))

select count(DISTINCT...