Is this what you meant?

The times went down from 12 seconds to 6-7 seconds 🙂

Can you see anything i did wrong, or any other improvements?

Thanks!

USE [JobPortal]

GO

/****** Object: StoredProcedure...

Thanks, i will keep playing with it, until i figure it out!

I'm not quite sure if this is what Gail meant, but i have a couple of errors and i'm not sure how to fix them.

Msg 156, Level 15, State 1,...

GilaMonster (9/26/2011)

---

Try some temp tables. Rather than a CTE for the Resumes, insert that into a temp table, index it and then select out just the ones you want. Also...

USE [JobPortal]

GO

/****** Object: StoredProcedure [dbo].[GetAllResumesSearchedDynamicQuery2FTI9-26-11] Script Date: 09/26/2011 12:29:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

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

I am using RAID 10 for the data files

RAID1 for program files

RAID1 for log files

RAID0 for TempDB files

Thanks for the feedback everyone!

I have a variety of servers running DC's and Exchange 2010, 2007, 2003, CRM 2011, and two servers running seperate versions of SQL Server 2008 for different applications.

I have one...

You have given me some ideas, let me try a different method.

Thanks

I did an insert into, but it adds the data to the end of the existing data, which is why i need to do an sql update, not a sql...

The common field is the Id.

I am trying to create a new table with data from another database, and add the Id into the new table.

Is this a good reindex query?

Thanks

USE DBName

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM information_schema.tables

WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM...

Thanks!

FinalRowCount BETWEEN @fromRec AND @toRec

I keep getting invalid column name(FinalRowCount) on this line. Any idea why?

Thanks!

jwbart06 (7/18/2011)

---

Using

@fromRec int, -1

@toRec int -10

you are going to get row_numbers 1 through 10

on the between statement @fromRec and @toRec

So your results are correct, there is no way to...

The second set of records was:

FromRec = 1

ToRec = 20

Thanks!