could you please follow the second link in my signature block on how to post code so that we can help you out.

if you can provide create table statements, refactor...

could always set the source DB to read_only instead of single_user then set it back to read_write once done

take it you mean this statement

the query is evalutated at run time...

BeautyOfFinishingAt16:00

I'm unsure, its a 3rd party app and uses entity framework with all inline SQL so no procedures for me to look at.

I will pass this to the development team...

Sorry Gail, the indexid for both pages is 1, which is PK__PSX_PUBLICATION___300424B4

looks like a case for a cross-tab, see the links in my signature on how to get started

its 6 of one and half a dozen of the other with that as with windows auth, the auth is done via tokens with the domain controllers which reduces the...

what is your threshold for blocking processes?

ours is 30 seconds, so we have a job which runs the t-sql below, into a #temp, waits 30 seconds, runs it again into...

1HourLeftTill4DayWeekend

the issue is with FILEPROPERTY, its specific to the database context its running in

From BOL

file_name

Is an expression that contains the name of the file associated with the current...

could take a look at the attachment, this is what I have used in the past to populate a postcode table and then do a lookup to it for the...

Figured it out, enable trace flag 3604 then use dbcc page.

boths pages have MetaData: ObjectId = 789577851 which relates to PSX_PUBLICATION_SITE_ITEM in sys.objects

Hi Gail

There are only 2 indexes, the Primary key and the extra index provided above in the create table and index definition snippets.

I have attached the two plans for each...

yep, sorry, been one of them days, had my head in MDX all day.

I just thought to myself, why dont you see if the sql handle and plan handle are...