Are they all in the same filegroup?

Don't create indexes blindly off missing index DMV, you'll end up with massive numbers of duplicates and a large pile of useless indexes. Evaluate any suggestions made, implement if they're...

Same as the read uncommitted isolation level. Request no shared locks for the hinted tables thus allowing dirty reads. Additionally it allows allocation order scans (reads in physical order instead...

LutzM (11/13/2013)

---

But for the taks itself (taking aside the concatenation) your preferred solution is NOT EXISTS?

Is this "usually" the fastest solution for a large table against a small lookup table...

LutzM (11/13/2013)

---

GilaMonster (11/13/2013)

---

Jonathan Marshall (11/12/2013)

---

The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using...

Jonathan Marshall (11/12/2013)

---

The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using a computed...

Not database set to single user mode. Instance started in single user mode.

So have you checked the logs and proven that he did that? If you haven't, then you can't assume.

Check what logins you have. Make sure you haven't granted local administrators...

Please post new questions in a new thread.

Beatrix Kiddo (11/13/2013)

---

Can this be used as a way to get access if you don't know any of the passwords? I definitely...

You...

What happened, why is the database in Emergency mode?

And do you have your backups handy?

select count(*) from table WITH (INDEX=0)

That'll force a table scan instead of the usual scan of the smallest index that the optimiser prefers.

The default trace doesn't keep data forever. It keeps 5 files of max 20MB each. Could be the files have rolled over and the date of the alter database is...

Don't shrink to too small a size. Is 1GB enough for the regular operations on your database? If not, don't shrink that small.