Thank you

Thank you very much, will explore it now.

I could kick myself, I am running 2008 R2... so sorry

Thanks for your help, however I get this message

'LAG' is not a recognized built-in function name.

Hi,

There is a unique Id column in the original table, but is not nessarily incremental, but is unique.

Thanks,

Lewis

Hi,

I have reposted in here... http://www.sqlservercentral.com/Forums/Topic1695984-3077-1.aspx

Thanks

http://www.amazon.co.uk/Microsoft-SQL-Server-2008-Dummies/dp/0470224657/ref=sr_1_1?ie=UTF8&qid=1407852573&sr=8-1&keywords=sql+server+for+dummies

Hi,

Thanks, I managed to get it working dynamically.

Thank you for your original query which I used.

Hey, yes I know, I tried but couldn't get it working dynamically so thought I would repost so that it would come to the top of the forum page to...

Cadvre... thanks very much the issue was resolved by simply adding the index...

USE [MLex_Editorial]

GO

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]

ON [dbo].[ContentSearchTable] ([ContentID])

GO

Hi,

Thanks all for your comments.

So I have disabled the trigger and you were right because that improved the performance. However the problem I have is that this problem is...

I should also mention that both tables have full text indexes on them.

Sorry for the lack of information, my bad.

The DDL of the table is as follows.

CREATE TABLE [dbo].[Content](

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

[LegacyID] [int] NOT NULL,

[ContentType] [int] NOT NULL,

[CaseId] [nchar](50) NOT NULL,

[Title]...

The update statement is as follows.

UPDATE Content SET ContentType =5,CaseId ='',Title ='XYZ',EventDate ='1980-01-01 00:00:00',Location ='',Address ='',FileName ='',URL ='',IsArchived =0,Author ='Magnus Dowson',LastUpdate ='2013-04-11 16:49:16',AlertSent ='2013-01-15 17:12:04',Published ='2013-01-15 17:08:22',IsPublic =0,BannerCode ='',IsDraft =0,IsAlertSent...

OK,

So as you described below is correct, that's the original 🙂

So

1

--2

--3

--4

5

--6

--7

--8

To put it in to perspective:

Each id in the table above represents a Subscription to a annual service that...