Based on that it doesn't look like your log backups will be that big. Another question, what performance measures are you seeing for avg disk sec / read and avg...

Definitely a wise thing...

Yes, if you are not using updateable subscriptions it is safe to remove it.

Along with Chris's note, can you run the following;

dbcc sqlperf (logspace) and provide the output.

Thanks.

Wow - you have 50 GB of changes every 30 minutes on a given database and 20 GB on all others. That is a lot of data change in a...

...and how frequently are you running them?

How are you doing your log backups? Are you using a third-party program for those backups? How large are the log backups?

LOL - I'll concede. Sort of like trying to claim the idea behind the internet huh? 🙂

Once you use a Tally table you will want it around for other uses as well which is why master is recommended. They're pretty handy.

Stefan Krzywicki (2/17/2012)

---

GSquared (2/17/2012)

---

Evil Kraig F (2/17/2012)

---

GSquared (2/17/2012)

---

bitbucket-25253 (2/17/2012)

---

Way way back Virginia Tech was working on a system with a buried cable in each lane, a sensing mechanism on the...

I guessed something like that so formatted the dates you provided to meet my date...

I'll add a small change to the version the previous poster put up using a CTE numbers table. This result will get all the days and I have spot checked...

Sounds great. Thanks for checking out the article as well....

Yes. I'm thinking that you don't need the second table but could rather just do that with a query and be able to get the data in the format you...

Wondering if you have considered writing a query that will put the data in the format that you are looking for?..? That will allow you to load the data as...