I so wish I knew why this happened....

Solution's simple, though far from obvious.

Run DBCC OpenTran. There'll likely be a reference to replicated and unreplicated LSNs. The replicated will probably be...

I wrote up my goals and intentions on my blog. Post scheduled for midnight (my time). What I'm focusing on next year is not SQL Server though.

This is insane. There's a nested loop join between thousands of rows. I cannot see why that loop join is there, it's the worst kind of join for those row...

You should not even be considering updating the system tables unless you are willing to deal with a corrupt and unusable database afterwards. Say you did update the xtype, now...

digitalox (12/30/2009)

---

Seems to be it would be more useful if the user_lookup values were populated in each instance of the NC indexes instead so that you could identify the offending...

Interesting. Same backup? Same time of day?

Are you sure the state is 'recovering' not 'restoring'?

Not really...

I would really question the accuracy of that script. The only valid values for...

digitalox (12/30/2009)

---

This confused me because if the user_lookups represents the bookmarks by a NC without sufficient cover, then how can that column have any bearing on the effectiveness of the...

Makes that the boot partition, ie the...

Recovery (restart-recovery) goes through the logs, rolls back transactions that started but never committed and rolls forward transactions that did commit. The latter may not be so relevant for a...

I'm going to guess...

Ascending date column and the query's filtering for the latest records. Right?

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Rather than using the table viewer (which can be a little glitchy), use the T-SQL commands.

UPDATE <TableName>

SET <Column name> = 'facebook'

WHERE <Column Name> = 'acebook'

This will update all...

That shows the lookup done to the clustered index. So whenever a NC index is not covering and there's a key lookup, that's a lookup to the clustered index.

As far...