I mentioned the execution log maintenance process because I have read a reference to that - someone reported that it was putting long lasting locks on the log table which...

Can you split the workload into smaller pieces, and/or distribute the subscriptions over a longer period?

I know that's kind of a bandaid-type fix, but it may tell you if the...

I think for a first pass, just identifying your HEAP tables is enough - in most working environments, you will probably want to build the clustered index on existing columns....

Excellent summary and examples - especially appreciated the animation showing how to navigate the interface!

As a practical note, I recommend not leaning too heavily on color to provide meaning -...

I like the technique, and learning about a function that was new to me, but the article is confusing in a couple of ways.
The narrative talks about discount, but...

One of the things I learned from my father is "Bad news gets worse with age."

When you make a mistake, I agree with all that has been said...

I think the default retention period for SSRS logging is 60 days, rather than 30 - unless you specify an amount of time in the queries, they are actually 'reports...

Try setting the 'Can Grow' and 'Can Shrink' properties of as many objects as possible to 'false' - all of them, if your report will support it. This means that...

This sounds very questionable, from what you tell us, but I suppose there could be something unstated about the situation that MIGHT make it reasonable.

More information would help, such as...

If you do use a Semester table, suggest that you have a final record where the semester name is something like 'update the semester function', to provide a clue for...

Data breeches? Like Sander Berger wore?

Agree with you on the need for tweaking, but you may need to look at the width of your report body along with the size of your margins - together...

Possibly you could reference the extended property in a specially created view? Or do something else on the database side using stored procedures or functions so that the report model...

To amplify, you want to make sure that the width of the body of the report will fit on a single page - this would be the width of the...

From the Books Online File:

Image Rendering Extension

The Image rendering extension renders reports to bitmaps or metafiles. The extension can render reports in the following formats: BMP, EMF, GIF, JPEG,...