If you don’t have a clustered index on a table, you can have serious problems with empty pages that never get de-allocated. I once found a heap table that...

scogeb (11/2/2012)

---

I like to think there is always an exception to every rule. Take for instance a table that ALWAYS has inserts and NEVER has any selects. Putting...

mgrubbs 50094 (11/2/2012)

---

It looks like 6 of the tables are heaps. Is it just ALTER TABLE <TABLENAME> REBUILD?

Is there any risk to doing that?

Also, there are no varchar(max), but a...

You should run DBCC CHECKDB first to make sure there is no problem with the database.

If DBCC CHECKDB shows that the database is OK, then

Rebuild any tables with LOB columns...

Luis Cazares (11/1/2012)

---

Michael Valentine Jones (11/1/2012)

---

There is a good chance that all the space is being used by the transaction log. If the database is in full recovery mode...

There is a good chance that all the space is being used by the transaction log. If the database is in full recovery mode and you are not doing...

capnhector (11/1/2012)

---

i would tend to disagree. you need...

It is probably best if you avoid triggers completely until you have a lot of experience with SQL Server.

What is the code you tried that didn't work?

If the leaf level fragmentaion is low, it would probably be much faster to do an index reorganize(defrag), instead of a rebuild.

Or just leave it alone.

Yes. If you want, you can change the DB to read/write after the restore.

Follow-up question:

What are the properties of brown ACID?

Jeff Moden (10/31/2012)

---

Michael Valentine Jones (10/31/2012)

---

I like to ask a couple of easy trivial questions to get things started, and then ask one that a lot of senior DBA might...

I like to ask a couple of easy trivial questions to get things started, and then ask one that a lot of senior DBA might stumble over. Just to...

Make sure you know what you mean by "timestamp".

TIMESTAMP is a...