Search "database growth" and you will find quite a few posts & scripts

jpSQLDude (4/28/2010)

---

Another question, if I may: if you look at that code I posted above, there is a simple command to list all the traces running on a server:...

striker-baba (4/28/2010)

---

Actually, My C drive is 40 gb ... and

I see some users have lots of data like around 11 gb of data on their personilized desktops...

I dont know...

GabyYYZ (4/27/2010)

---

1. Security: working on it...

2. Processes: what's a process? 😀 (yeah I know, this is forcing us to think)

3. Roles: probably the easiest piece so far we're dealing...

If these are important databases with frequent activity, then it's strange you are only taking transaction log backups once a day at 3:30 am. If you have a failure...

OP's DBA was "helping", but not sure that it was...

Ideally, you would leave the free space there so it's available as your database grows. Then it does not need to re-allocate the space. If you absolutely need the space...

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The...

There are probably no backups, so it may not matter how the t-log is shrunk.

So ... you would advise against creating a nightly...

Did you take a full backup after switching back to full recovery ?

We posted 2 pages the other day trying to help you with this problem. Instead of starting a new thread, you could read the replies, answer the questions, and read...

Idera also has a more straight forward Object Level Recovery. We use Redgate here because it was in place before I started, otherwise I'd lean towards Idera that I...

You could create an insert trigger that puts the value NAME into another table. It would overwrite whatever the previous value was with the new value. Or add a...

striker-baba (4/23/2010)

---

Thanks to all for the replies.

I ran the query

SELECT

a.index_id,

name,

avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(' dbname '),OBJECT_ID(' table a '),NULL, NULL, 'limited') AS a

JOIN sys.indexes AS b ON

a.object_id...