Michael Valentine Jones (5/19/2011)

---

jpSQLDude (5/19/2011)

---

Ninja's_RGR'us (5/19/2011)

---

That shows a basic lack a comprehension in logs. Wether you take 100 log backups in 24 hours or only 1 the total size...

Michael Valentine Jones (5/19/2011)

---

One of the reasons to run transaction log backups more often is to control the size of the transaction log files. As was said in another...

Burhan Insel-262978 (5/19/2011)

---

We, employees,...

Well then you don't have all the business requirement. That's a very...

jpSQLDude (5/19/2011)

---

Ninja's_RGR'us (5/19/2011)

---

jpSQLDude (5/19/2011)

---

SharePoint is used by office workers during regular business hours, so there should hardly be...

NO.

How much data will you keep out of 91 M rows?

tgarland (5/19/2011)

---

I don't disagree that having the correct nonclustered index will produce better results but the current index seems to be pretty selective. Not knowing how many services there...

Steve Jones - SSC Editor (5/19/2011)

---

I'd highly disagree here. It's rather insulting to make this comparison and it's more extreme than...

tgarland (5/19/2011)

---

I don't necessarily think this is an indexing problem. You want to try and keep the number of included columns to a minimum. Looking at your image,...

At 1% of the data you should be able to get a seek (not garanteed, bu very probable).

Including all the columns of the table would mean that you have 2...

Awesome, thanks for the feedback!

I was talking about local printer. Maybe I misunderstood how you are generating the report.

It has to go on a group or page header (footer) I don't know any other ways.

jpSQLDude (5/19/2011)

---

SharePoint is used by office workers during regular business hours, so there should hardly be any transactions...

I understand your need, but I don't see your screen and it makes it hard to debug.

Have you tried printing to pdf in another page format? Sometimes the default...