Thanks for the feedback guys!

BTW I have hired consultants, and Microsoft Enterprise support was not free either, but it seems to be a case of "the more cooks spoil the...

I dont know what they do, other than make the query faster!

I have had a few DBA's and Microsoft Enterprise support work with me on this query, and was told...

Here is the plan.

USE [JobPortalIANdell297061412]

GO

/****** Object: StoredProcedure [dbo].[GetAllResumesSearchedDynamicQuery2FTI_6-19-12part2] Script Date: 6/20/2012 10:01:39 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- ============================================= ...

At the moment i am using the following:

inner loop join alldocuments dc With (nolock) on p.idnew = dc.id

set @QueryCondition = @QueryCondition + ' and contains(dc.doccontent,''' + @Name1...

Its a question, i am trying to use the select within the contains statement and cant get it to work!

I removed the ‘GUID’ field and used an ‘INT’ ID field instead for the primary key and clustered indexes, and got the query down to:

SQL Server Execution Times:

...

I used a Temp Table, but it made the query a lot slower!

I also used the loop joins and nolock because they improved performance.

By combining CTE, loops joins and nolock,...

Thanks guys!

GilaMonster (6/4/2012)

---

Try breaking the query down to use an intermediate temp table rather than a CTE, see if that helps at all. Maybe try breaking it down even further with...

This is my current execution plan.

To search 6 months of resumes for 'java', takes about 4 seconds and returns 22k records.

I would like to get that...

SQLKnowItAll (6/4/2012)

---

isuckatsql (6/4/2012)

---

I have four years of data that i would like to partition.

Would it be best to do four partitions on one year, or eight partitions on six months,...

I have four years of data that i would like to partition.

Would it be best to do four partitions on one year, or eight partitions on six months, and allow...

GilaMonster (6/4/2012)

---

The one in the initial post? It won't work, it's Oracle syntax not SQL Server

Do a count and filter...

SQLKnowItAll (6/4/2012)

---

SELECT ID,...