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...

That was my thinking as well, but then I thought that the select is waiting on the insert so shouldnt I optimise the insert first.

Pretty sure will find out once...

Thanks Ian, we would have to look at a plan guide as the app is a 3rd party content management system and cannot be changed.

Now this is all new to...

chetanr.jain (4/5/2012)

---

Nope..

It allowes me to user STOP AT command in Full database restore.

However, it allowes me to specify the time between only when full backup started and completed.

THis does not...

yes its a free tool

you could try modifing the scripts it generates for system and item level roles, but these will only be deployed when you deploy the script, its...