No good news then.

The DB is damaged in such a way that CheckDB can't run, that makes the corruption irreparable. At this point I'd normally say 'restore from backup', but...

The...

Blog and email working again. Finally.

I hate DNS-related problems.

All corruption-related...

Yup.

I strongly suspect it's not repairable. The page number the error gives is within the range I'd expect system tables...

AAAHHHH!!!!! http://www.sqlservercentral.com/Forums/FindPost1545323.aspx

Additionally, logic-wise this is questionable - T1.TEMPLATE_FLG != 'Y' AND T1.TEMPLATE_FLG != 'P' OR T1.TEMPLATE_FLG IS NULL

AND and OR without brackets. What's actually meant by this?

kenneth.mofokeng (2/26/2014)

Since you don't have backup , try to...

Server-side trace to files on a fast local drive is my preference. Less overhead than using the Profiler GUI no matter whether the GUI is sending stuff to screen or...

Too small for rebuilding to matter?

It's unlikely that rebuilding the index fixed the problem. It's far more likely that the statistics update which the rebuild performs fixed your problem. Consider...

I hope that database isn't very important... It's very likely there will be some data loss here, it's possible that said data loss could be the entire DB.

Find some downtime,...

Table definitions, index definitions and execution plan please (estimated if the query won't complete, actual otherwise). See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Weird question.

I think the key here is 'return certain columns', not return certain rows. A view or function can indeed return different rows based on a pk value, but to...

Restore from a clean backup (backup taken before the corruption occurred)

No, 150.

Duration is clock time. The amount of time elapsed between a query starting and a query completing. CPU time is the amount of time spent executing on the CPU, calculated...