Should be fine, I've done that before. Can you post the code?

Table definitions, index definitions and execution plan please, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

That sounds more like a blocking problem, or...

I'm going to ask the same question I ask every time you post a question like this...

Is that query a problem? Is that operator the problem?

Costs are relative, costs MUST...

http://thomaslarock.com/2013/05/top-3-performance-killers-for-linked-server-queries/

Huh? If you're using SQL 2012 (and I assume you are since you posted in the SQL 2012 forum), you can use Extended Events...

Yup, perfectly possible. It's not one foreign key though, it's two foreign keys, one referencing each of the tables

CREATE TABLE sample1(id INT PRIMARY KEY)

CREATE TABLE sample2(id INT PRIMARY KEY)

CREATE TABLE...

peter.cox (2/12/2014)

---

Most of the time the step takes 20 mins, and all is sweetness and light. Sometimes (once every three weeks?) the step takes over 2 hours (i think the...

I'd second Jimbo's recommendation, either 6 or 12 files of a combined size of 120GB (so 6 files of 20GB or 12 files of 10GB)

That said, why are you splitting...

You are not going to like the answer...

That's not repairable. Script all objects (and hope that none fail), export all data (and some may fail), recreate the database.

Oracle_91 (2/11/2014)

---

2) Secondly, why can't I have the database which is participating in database mirroring as SIMPLE recovery model? In Log shipping we take transaction log backups and there is...

amy26 (2/11/2014)

---

The thing I find odd is that in the error log table, it is capturing a problem with my main stored procedure (the one I posted here) with a...

I've just spent part of the morning (teaching database design today) explaining why a business requirements document needs to be specific and detailed (and telling horror stories of times I've...

Ok, in that case (0%, 0sec) it's probably a stuck rollback (they happen from time to time, it'll be trying to get something that it can't get) and it's usually...

Just run DBCC updateusage without parameters, schedule it for your next maintenance window, whenever you do index maintenance.