Core of your problem

Estimated rows 1

Actual rows 2887406

That's on the index seek for the REsult table. Probably stale or missing stats, could be parameter sniffing, without more details pretty hard...

Edit again...

That looks like a default constraint. As such you won't find it in the DMV that lists foreign key constraints.

To alter the column you need to drop all constraints,...

What do you...

No.

It won't be fragmentation as the query optimiser does not take fragmentation into account when costing the queries. It might be stats, the insert will trigger an auto-update which is...

Sean Lange (7/11/2013)

---

OK I will show my true American colors here. My wife's company just got a new client in Newfoundland. She is going to have to travel there this...

To be honest, I'd test out indexes on a table no matter how small it is (OK, maybe not a 1-row table). If the index improved query performance, keep it....

Firstly, shouldn't

SET @query = 'SELECT * FROM OPENQUERY(' + @query + ','

actually be

SET @query = 'SELECT * FROM OPENQUERY(' + @linked_server + ','

?

As for the syntax error, print out...

The default trace automatically cleans itself up. It retains 5 files of no more than 20MB each, when it creates a new file it automatically deletes the oldest file.

That is indeed how it works.

but what I am seeing is that the count, and...

Sapen (7/11/2013)

---

Check for the location where your ldf and mdf files are and As long as you have them try doing a detach/attach and it should bring the database to...

No.

2) if the current version becomes corrupt can you go back to...

Now out of ideas...

You don't. 2012 only allows partially contained.

If you don't have a backup then you cannot get the old values back. Unless you did the update in an explicit transaction and that transaction has not yet been...