It's because of the '0:00:00' you have in the datediff. With no date specified, that becomes 1900-01-01 00:00:00.000, which is probably not...

Brandie Tarvin (8/11/2016)

---

3) Am I right in thinking that an INNER JOIN statement where an unindexed column is being used on the left side of the ON against a clustered...

I'll file a complaint with his boss. 😉

as in, drop the spacial index and recreate it.

TomThomson (8/10/2016)

---

Any particular place in Scotland? I'm...

First time in years that I'm flying somewhere just for a vacation, no conferences involved. Scotland, to save anyone from wondering.

Someone please keep an eye on the corruption forums, I've...

You can try that, but I'm not sure it'll fix everything.

Unable to read and latch page (1:5609991) with latch type SH. 23(failed to retrieve text for this error. Reason: 15105)...

If you're absolutely certain that table_xxxx has no important data, then you can run CheckDB with the repair_allow_data_loss option and it will fix the damage.

joe 92217 (8/9/2016)

---

My idea was to do a RESTORE to a temp db of the *.bak and *.trn up until the hour the event occurred and then somehow view all...

Please run the following and post the full output

DBCC CheckDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS

You really don't need to use such a large font...

SQL ignores trailing spaces when comparing strings. If it didn't, you'd never be able to compare a char(10) to any other...

Yup, not a surprise there, You do need some index/stats maintenance. Without...

I wouldn't recommend running that during peak time. To be honest, I wouldn't recommend running that specific stored proc either, there are better ways to update stats (the explicit UPDATE...

Minimum config isn't necessary. SQL just has to be started in single user mode.

6 year old thread, and a completely irrelevant reply to boot.