A view is a select statement, nothing else. No procedures, no assignments, no parameters, no variables.

Because they're not designed to be used the same way. It's got nothing to...

VastSQL (7/20/2016)

---

GilaMonster (7/20/2016)

---

You don't need to quote the whole thing again.

Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what...

You don't need to quote the whole thing again.

Is the CheckDB output in the inital post the pre-repair output (as your post implies) or the post-repair output (what I asked...

Jeff Moden (7/19/2016)

---

Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some...

Is there by any chance a DDL trigger on that instance?

smthembu (7/19/2016)

---

I've been monitoring the load on the VM and noticed the CXPACKET wait was too high, so for now I have changed the maxdop to 1 and cleared the...

Was the...

Not opening here until late August afaik.

Nothing you've said indicates a problem that needs fixing.

Sys.dm_exec_requests will frequently show a process as 'self-blocking' when that process runs in paralle (as CheckDB does) and the waits are normal...

CAST the output as TIME

5033, or 5023?

Filtered index won't work in this case, as the filter on an index has to be deterministic. Can't filter for timestamp > dateadd(hh,-2,getdate())

Msg 10735, Level 15, State 1, Line 8

Incorrect...

If you are running SQL 2008, then a server-side trace with Audit login success and Audit logout. If you're on 2012 or above, the same thing with Extended Events.

You are updating the clustered index, as the clustered index *is* the table. All of the columns in the table are part of the clustered index (not the key, but...