Don't make the mistake of thinking that multiple...

Please post the full and complete, unedited output of that command (you've left out at least one line, possibly more)

Unless all those files are on different physical drives, fewer bigger files is better. There's no gain from having lots of little files...

You have a table or index with a - in the name and your code doesn't wrap table and index names in []. You're just going to have to go...

Please run the following and post the full and complete unedited output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

If you're getting repeated corruptions, there's something wrong in the IO subsystem. Check...

Maybe. Depends why TempDB's growing.

If it's due to hash and sort spille, adding memory may help (optimising queries may help more). If it's due to temp tables and table variables,...

REbuilding indexes is done with ALTER INDEX ... REBUILD. That's all that's needed.

Was the long query not to identify which indexes needed rebuilding perhaps?

Jeff Moden (1/2/2013)

---

GilaMonster (1/1/2013)

---

Jeff Moden (12/31/2012)

---

The first thing I see (same as what Gail posted) is the HAVING clause which is executed only after all the other code has executed....

Safe. Not usually a good idea, but safe.

If you decide to shrink, you need to rebuild all your indexes afterwards. Don't shrink as small as possible, shrink to a sensible...

opc.three (12/31/2012)

---

Trace Events will not contain plan_handle. I was talking about Extended Events (XE). XE is a new tracing sub-system introduced in SQL Server 2008 that will eventually replace the...

Jeff Moden (12/31/2012)

---

The first thing I see (same as what Gail posted) is the HAVING clause which is executed only after all the other code has executed. I recommend...

No way to directly do that, the execution plan event does not have duration as a column.

One way to do this is to first capture procedures running slow and then,...

Backing up the log once a day? That's useless for recovery. It means you have...

Maybe. You'd need...

Per-index. Look up Alter Index. The Norecompute setting is the setting you want.