striker-baba (4/23/2010)

---

I tried to query the fragmentation stats on that table.

using

SELECT

a.index_id,

name,

avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, NULL) AS a

JOIN sys.indexes AS b ON

a.object_id =...

Richard M. (4/23/2010)

---

You might want try running that dmv with the 'LIMITED' option:

FROM sys.dm_db_index_physical_stats (DB_ID(' DB '),OBJECT_ID(' Table'A' '),NULL, NULL, 'LIMITED')

as it will have better performance, specially if it is...

What have you tried so far ? Have you searched for any information on the subject ?

Grant Fritchey (4/21/2010)

---

That's...

Here's a thread on the topic of DB growth & Capacity Planning.

http://www.sqlservercentral.com/Forums/Topic869838-146-1.aspx

Maybe I jumped through hoops that I didn't need to ?!

I made a version of Lowell's trace, and put it in a job. Then the job is scheduled to start whenever SQL restarts.

http://www.sqlservercentral.com/Forums/Topic735841-146-1.aspx

I changed the path, so that it creates...

You are correct.

You can generate the code. Open the job, uncheck the "enabled" button, then "Script to new window"

I can't replicate that in 2005. Tried a "regular" job and a maint plan...

When you specify the file extension do not include the "dot". So use BAK, not .BAK

I agree. For production, I backup every 15 minutes

You need to enable Mail in SQL ServerAgent Properties -> Alert System

Then I think you need to restart SQL Server Agent (?)

The index hint works with a select. The problem is that I am doing a lot of updates.

Maybe,.. join the table to itself, with a hint on the join. But I don't have a unique index to join on.

There's a "Reporting & Logging" button on the tool bar. You can uncheck "Generate a text file report". Or, if you want some reporting, leave it checked, and create a...