I modified as following and I think it's little bit changed. I removed tep tables and use built-in paging.

ALTER PROCEDURE [dbo].[spGetSiteListFromTagPager]

@Tag nvarchar(64),

@page int = 0

AS

DECLARE @TagID int

SET @TagID = (select...

I didn't understand why you ask to add index for description field, it is not used on where clause?

Well SUBSTRING is not important too much so I removed it.

I think it's better to share table DDL.

CREATE TABLE [dbo].[Sites](

[SiteID] [bigint] IDENTITY(1,1) NOT NULL,

[SiteUrl] [varchar](120) NOT NULL,

[SiteFirstCheckDate] [datetime] NOT NULL,

[SiteLastCheckDate]...

Thank you for your advice, I changed as you written but it didn't change.It took 38 seconds

Description field type is nvarchar(2000)

There are other queries take huge executon times.

I believe that...

Hello Steve,

You're right. Let me give detailed information.

My website is http://www.websiteanalyzer.info

It analyzes websites and give information to webmasters for better SEO.

Websites have keyword metatags(one to many relationship) and for same...